Configure sqlfluff to auto-format SQL files

[nyurik]

Something like this should be added to the root .pre-commit-config.yaml file to configure sqlfluff.

This needs a more thorough configuration, e.g. maybe different spacing, alignment, capitalization, and other settings. We might need to create a dedicated .sqlfluff file with all these settings.

   - repo: https://github.com/sqlfluff/sqlfluff
     rev: 3.3.1
     hooks:
       - id: sqlfluff-fix
         name: sqlfluff-fix
         args: [ "--dialect", "postgres" ]
         files: '^.*\.sql$'