SQLrc

TODO

• joins
• select aliases
• generated file warranty
• capitalized params warranty

Limitations

1. Table definition:

Each column must start with new string!

If in column definitions, tokens PRIMARY KEY or NOT NULL are not found, codegen outputs warning

Original docs: https://www.sqlite.org/lang_createtable.html

2. TBD Select statements off docs

!!!

Alias for select ... from TABLENAME as ALIAS; are supported only with AS keyword (any case)

This requirement is only applyable for top level select statements

!!!

2. With-statements

With statements (CTEs) are not supported

3. Aliases

Table field is searched by regex: /[\w^]([a-zA-Z_0-9]+)[\w$]/

Type of the returning field resolved by the type of the table field.

(So, type convertions are not supported, feature requests are welcome)

When aliases skipped you can have following situation.

sqlite> select t.id, u.id from users u left join transactions t on u.id = t.description;
id|id
1|1
2|1
3|1
4|2
|3

So, prefer doing something like

sqlite> select t.id tid, u.id uid from users u left join transactions t on u.id = t.description;
tid|uid
1|1
2|1
3|1
4|2
|3

4. Resolve return type

When resolving return type for insert, update, delete queries the first of insert into {tableName}, delete from {tableName}, update {tableName} is considered affected table, so for

INSERT INTO products (name, price)
VALUES (
    'Phone',
    (SELECT price FROM (
        DELETE FROM temp_prices 
        WHERE product_name = 'Phone'
        RETURNING price
    ) as deleted_price)
)
RETURNING 
    id,
    name product_name,
    price * 0.2 tax,
    price * 1.2 price_with_tax;

CASE-WHEN statements are not supported