3 ms·
The best I've seen is jetbrains. Not only does it parse the query but it matches against actual tables if you give it a source. The crazy part is it can do thi
by ninetyninenine 2y ago
The best I've seen is jetbrains. Not only does it parse the query but it matches against actual tables if you give it a source.
The crazy part is it can do this for a SQL string in your code.
- mdaniel 2y agoNot just in code, anywhere that accepts a comment (or carries a JSON Schema), e.g. # just as an example, I'm pretty sure that # IJ already knows this is SQL spring: datasource: hikari: # language=sql connection-test-query: SELECT count(1) FROM my_table and also in not-obviously-sql literals #!/usr/bin/env python # language=sql MY_AWESOME_QUERY = """ WITH awesome AS ( -- ... ) SELECT * FROM awesome """