Support MySQL

[EvgSkv]

We should add support for running programs on MySQL database.

[th9195]

我也这样任务， 先支持当前主流的数据库程序， 才有更多的学员更快的上手。

[thesakshidiggikar]

ok! this is something which I'm woking with MySQL and Sql since past few years, can i get to know how can i contribute in it .

[EvgSkv]

@thesakshidiggikar I just realized that marking this bug as a good first issue was probably too optimistic! Adapting a new engine could be a quite involved task, but if you are interested in working on this, you are very welcome!

Various SQL dialects, like MySQL are configured with dialects file: https://github.com/EvgSkv/logica/blob/main/compiler/dialects.py

You'd need to create a dialect for MySQL and implement all of the functions, describing how the engine-specific parts of the query are to be produced for MySQL.

It is likely to be quite a bit of work and time investment, but if you are interested in working on this I'll be happy to answer any questions you have on the way.