Hello everyone,
I’m currently in the process of making a fully-typed SQL client to release to the public. It also includes a schema builder.
It supports all native functions (like now())) and supports foreign keys, etc.
Here is a small demo of it. Currently it doesn’t connect to the database as that is a low priority, but it properly formats queries and at some point will automatically escape values.
Currently, db:Query() just formats the query and returns it.
Let me know if there is anything I need to improve!
This is the code I used:
This is the result of the insert query:
This is the result of the select query:
I am soon going to be adding all the methods (delete, alter table, etc.), but for now, I just wanted to show it to everyone.
The schema builder: