Fork me on GitHub
#other-languages
<
2021-09-15
>
pavlosmelissinos15:09:29

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

marciol22:09:39

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

pavlosmelissinos23:09:21

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.

marciol23:09:57

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