4 ms·
Interesting approach. But for me the main disadvantage of SQL code embedded in other language is lack of syntax highlighting/checking. I've had the best experi
by maxxk 3y ago
Interesting approach. But for me the main disadvantage of SQL code embedded in other language is lack of syntax highlighting/checking.
I've had the best experience with embrace-sql which translates sql-files with magic comment-delimited parametrized queries to python-callable modules: https://pypi.org/project/embrace/ https://pypi.org/project/embrace/
- dr_kiszonka 3y agoI wish there was a way to get around the syntax highlighting, checking, and completion issue. Pandas has a nice `query` method, which is hard to use for the same reason. https://pandas.pydata.org/docs/reference/api/pandas.DataFrame.query.html#pandas.DataFrame.query https://pandas.pydata.org/docs/reference/api/pandas.DataFram...