honeysql

Discussion of https://github.com/seancorfield/honeysql :slightly_smiling_face:
az 2021-04-27T22:50:38.200100Z

Hi all, is there a way convert raw sql to honeysql compliant data? I have a bunch of sql I would like to convert.

NoahTheDuke 2021-04-27T23:35:19.201100Z

Depending on how much effort you want to put in, you could convert the sql to AST nodes and then convert that to honeysql style nodes

seancorfield 2021-04-27T23:37:55.201800Z

The grammar for SQL is extremely complicated and is also different for each database so this is a very hard problem to solve.

seancorfield 2021-04-27T23:38:46.202700Z

If you have “simple” SQL, you might be able to do at least some of it via regex-style parsing but it’s still going to be a lot of work @limix

az 2021-04-27T23:39:14.203400Z

Thank you, makes sense

seancorfield 2021-04-27T23:39:20.203600Z

(it’s been requested a couple of times against HoneySQL and I’ve rejected it each time as being effectively intractable)