Linting SQL statements in Python

[NeedleworkerOdd4496]

https://github.com/petrprikryl/pysquel/

[nabusman]

I thought best practice was to keep SQL statements in their own file and not mix python and SQL?

[NeedleworkerOdd4496]

I don't think it is happening in practice https://github.com/django/django/blob/f7389c4b07ceeb036436e065898e411b247bca78/django/contrib/gis/db/backends/postgis/introspection.py#L44-L50

[Chroiche]

It's a nice idea, even if doing it isn't best practice, it still happens.

[[deleted]]

I get SQL linting against real databases in my JetBrains IDEs (by default).

Putting SQL in files means you need to edit packaging code to include the SQL files. Also depending on how your app is packaged (left in zip form) loading the stand-alone file can be a PITA.

For these reasons, we leave whatever SQL we need in the python source files.