sql-in-ts

0.0.13 • Public • Published

WIP: Really fully type safe (Postgre)SQL eDSL in TypeScript, with a small generator reading SQL DDL and outputting TypeScript table definitions.

Operators:

As seperate functions? Or as methods on Expr? -> We would then need BooleanExpr, NumericExpr, ... Also .isNull() would have to be only accessible on Expr's that can actually be nullable...

IPV eerst select(demoDb) -> Eerst from -> en dan kan je nog kiezen later of je select of insert doet?

Capturing GROUP_BY errors seems insanely hard, eg:

SELECT user_id, json_build_object('bl', emails.id) FROM ... GROUP BY user_id -> fails SELECT user_id, ARRAY_AGG(json_build_object('bl', emails.id)) FROM ... GROUP BY user_id -> works : NOTE: is that because json_build_object is not an aggregate function? => Might be possible, once we groupby we can only use a/ grouped on expressions, b/ aggregate functions

SQL Optimization: https://github.com/tobymao/sqlglot/blob/main/posts/python_sql_engine.md#optimizing

Readme

Keywords

none

Package Sidebar

Install

npm i sql-in-ts

Weekly Downloads

3

Version

0.0.13

License

none

Unpacked Size

766 kB

Total Files

12

Last publish

Collaborators

  • frigoeu