perf(sql): don't compile pretty sql by default

[kszucs]

We have been compiling pretty formatted SQL queries so far. While this was handy, pretty formatting doesn't give any value when directly passed to a backend, it mostly matters when presented to users.

Compiling a big query like the one provided in #8484 takes 3.83s with pretty=True while it takes almost half the time 2.17s with pretty=False.

[github-actions]

ACTION NEEDED

Ibis follows the Conventional Commits specification for release automation.

The PR title and description are used as the merge commit message.

Please update your PR title and description to match the specification.

[cpcloud]

Does the use of formatted SQL have a meaningful impact on SQL generation performance?

[kszucs]

Depends on the expression:

• ibis/tests/benchmarks/test_benchmarks.py::test_compile\[large-duckdb\] shows 7% improvement.
• running the simplified reproducer from perf(sql): prevent sqlglot from extensive deepcopying every time we create a sqlglot object #8592 changes to 2.12s from 3.43s

While it is not significant in the first case, it is in the second.