For working with LLM-generated SQL, I highly recommend using @SQLFluff to perform static analysis on the query to make sure it is both sematically correct and safe
github.com/sqlfluff/sqlfluff
With SQLFluff, you can automatically lint your SQL code and correct most linting errors.
SQLFluff supports various SQL dialects such as ANSI, MySQL, PostgreSQL, BigQuery, Databricks, Oracle, Teradata, etc.
Link to SQLFluff: github.com/sqlfluff/sqlfluff
We recently released SQLFluff v2. This is a major upgrade including much better white space formatting and new rules naming convention.
github.com/sqlfluff/sqlfluff…
We’ve also got a fantastic community on Slack to help you get started, so if you’ve a missing syntax or feature and wanna fix that, or have just been wanting to get into open source for a while, then the SQLFluff project is a great one to contribute to!
github.com/sqlfluff/sqlfluff…
Using and exploring @SQLFluff for both linting and auto-formatting SQL. Very flexible and configurable. Honestly, can't find better in the open source space. Actively developed. docs.sqlfluff.com/
SQL PRs getting slammed with nits about formatting? You can save time and prevent PR nits fatigue using an auto formatter!
Enter SQLFluff, a linter with functionality to support templating (in dbt) and multiple SQL variants (even SparkSQL).
#SQL#dataengineering
Have you ever had to interpret an unreadable SQL query?
Don't be that person.
Format with SQLFluff, a dialect-flexible and configurable SQL linter.
It supports:
ANSI SQL
Athena
BigQuery
Hive
MySQL
Oracle
PostgreSQL
Redshift
Snowflake
SparkSQL
SQLite
and more.
👇
Nobody likes to feel dumb.
A teammate nit-picking your code can make you feel that way.
But it's important to stay consistent.
One solution: Implement a linter.
Two examples:
• @SQLFluff
• PyLint
Changes are less offensive when suggested by a computer.
SQLFluff 1.3.1 has just been released.
7 new contributors this time. Your help in improving SQLFluff is very much appreciated.
Full release notes here:
github.com/sqlfluff/sqlfluff…
SQL Fluff
If you thought that flint is only for code, think again - sql linter. Both formatter and error checking.
Releasing new version with a pr that I summited:
github.com/sqlfluff/sqlfluff…
Open source is so great
#opensource#SoftwareEngineer