Thanks for your report, yeah, this could be quite useful.

However I would be concerned about all the features that rqlite doesn't support. For example rqlite doesn't support traditional transactions, as most folks might expect. Do you think this is an issue?

This is the other prior art that might be relevant: https://github.com/benbjohnson/postlite

the most basic mode would be to just take sql commands from the client connection, forward it to the database and return any status codes and possible result sets.

i have also seen a lib that implemented mysql/mariadb protocol, but i am unable to find the link

i have been using crate.io over postgresql protocol almost a decade and they sport some unique sql syntax.

that said, ithink you dont even need to rewrite psql to sqlite syntax as the user should be readily aware what chimera he is using.

:-)

any updates or thoughts ?

No updates at this time. No strong objection to adding this, just didn't have the cycles to add it yet.