Allow SETTINGS Before FORMAT in DESCRIBE TABLE for Compatibility with SELECT Query

Why it matters

This feature improves query consistency and compatibility by allowing users to specify SETTINGS options before FORMAT in DESCRIBE TABLE statements, matching the established behavior in SELECT queries and resolving issues related to query parsing and execution.

How to use it

Simply place the SETTINGS clause before the FORMAT clause in your DESCRIBE TABLE queries. For example:

DESCRIBE TABLE my_table
SETTINGS <setting_name> = <value>
FORMAT <format_name>