chore(root) : Update pre-commit rules

[vperron]

The pre-commit packages were terribly outdated.

Can't update sqlfluff to v3 as the dbt templater is not compatible yet.

Also for ruff:

• first, format the files (ruff-format)
• then check them, fixing what can be autofixed along the way.