henry
henry
To resolve #286 ## Goal ```sql gluesql> SELECT 1, 'a', true, 1 + 2, 'a' || 'b'; ╭─────────────────────────────────────╮ │ 1 'a' true 1 + 2 'a' || 'b' │ ╞═════════════════════════════════════╡...
To resolve #418 ## Goal - Basic Derived VALUES ```sql SELECT * FROM (VALUES (1, 'a'), (2, 'b')) AS Derived column1 | column2 ---------+--------- 1 | a 2 | b...
To resolve #747 ## Goal `Spool` is the easiest way to export data. ```sql gluesql> .spool query.log gluesql> VALUES (1), (2); ╭─────────╮ │ column1 │ ╞═════════╡ │ 1 │ │...
## Goal It would be nice If we can spool the output of query to file. ## References ### Oracle ```sql SQL> spool query.log SQL> SELECT 1, 'a' FROM DUAL;...
This is subsequent PR of #648 ## Goal - Support `ORDER BY` clause in `VALUES list` ```sql gluesql> VALUES (1, 'a'), (2, 'b') ORDER BY column1 DESC; column1 | column2...
This is subsequent PR of #659 ## Goal ### Like Below, we will be able to create table with `Values List` ! ```sql postgres=# CREATE TABLE gluesql AS VALUES (1,...
## ORDER BY clause syntax ```sql ORDER BY { ColumnName | ColumnPosition | Expression } [ ASC | DESC | .. ] ``` Currently `ORDER BY` clause with ColumnPosition is...
## The `ROWID` pseudocolumn is the address of each row in the database. ## `ROWID` values have several important uses: - They are the fastest way to access a single...
# Currently in gluesql, we can select the columns not appeared in the GROUP BY clause. `GlueSQL 0.8.0` ```sql create table Item ( id int ,ratio int ,city int );...
Recently i needed to remove border line and use custom column separator but I couldn't find any similar one except `set_delimter` which fetches different result that looks like parsing a...