RoQuery - SQL Client

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:
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. :slightly_smiling_face:

The schema builder:
xq0Mc

2 Likes

Looks quite promising!
And I also like that you’re adding a schema builder like in MongoDB and/or TypeORM.

Also, out of curiosity, will this project be open source once released?

Yes, it will be open source. It is a personal side project, so it will be on and off, but there is some progress :slightly_smiling_face: