Do not restrict the use of SQL
You dont need to learn any new query language, you can use SQL with all its power and expressiveness.
Having the following query in select-products.sql
file.
TypeSQL will generate the types and function in the file select-products.ts. Then you can import the generate code and execute as following:
Do not restrict the use of SQL
You dont need to learn any new query language, you can use SQL with all its power and expressiveness.
Automatic CRUD generation
Typesql generates CRUD operations for the tables you specify.
Support for nested query result
You can get nested results for your queries.
No runtime dependency
TypeSQL is used only during development time, the queries are exected using the battle tested mysql2 driver.