other-languages

pavlosmelissinos 2021-09-15T15:51:29.001600Z

Please tell me there's a honeysql-like library for python ๐Ÿ˜„ I've used pugsql in the past, which is inspired by hugsql, but now I need to work with a more dynamic schema so it's not a very good fit unfortunately

marciol 2021-09-17T22:48:39.002Z

I think that the closest you can get in python is SqlAlchemy

pavlosmelissinos 2021-09-17T23:01:21.002200Z

Hey, thanks for the response. I actually asked at the python developers slack. Someone did recommend sqlalchemy core, which includes a query builder. Apparently it can be used separately from the ORM parts (yay!), which I didn't know. Another person recommended pypika, which is more lightweight. Unfortunately its api is not exactly functional but the library is definitely on my radar now.

marciol 2021-09-17T23:08:57.002600Z

Nice, eventually we need to work in other stacks, so itโ€™s good to know what to use when it happens.