Feature: compiler can read metadata without resolving values

Describe your changes

Some procedures require extracting metadata from the query, like the defined configuration or knowing which functions are being used, without actually having to resolve the query.

The current way to do this is just compiling the query, which will return some additional metadata along with other compiled output. The problem with this approach is that compiling a query is not always free, as some queries may use runQuery. This function is executed in compile time, since we need the result to be able to resolve other parts of the query. Since we need to get some of the query metadata instantly in some cases, we cannot depend on running queries just to read its configs.

To fix this issue, I have divided the current compilation process in two independent functions: compile and readMetadata:

compile resolves all variables, parameters and functions in a query, which are dynamic and dependent on context and may take some time depending on its content.
readMetadata in the other hand, returns information that is static in the query, like the defined configuration or the methods that are being called inside of it.

In order to read something as "metadata", it must be static and not depend on other values, parameters or functions resolved during run-time. Since I want the config to be part of the query metadata, I had to add these restrictions to the {@config} tag:

Config must be defined using only literal values. This means it cannot use variables or functions.
Config tags must be in the root level of the query. This means it cannot be used inside {#if} or {#each} blocks.

Checklist before requesting a review

[x] I have added thorough tests
[ ] I have updated the documentation if necessary
[x] I have added a human-readable description of the changes for the release notes
[ ] I have included a recorded video capture of the feature manually tested

🚂 TRENECITO. 🚉 Previous station: #439 🚉 Next station: #444

🦋 Changeset detected

Latest commit: 40017c39b6d6aeb8c3dc94c3406512daa86c4104

The changes in this PR will be included in the next version bump.

This PR includes changesets to release 17 packages

| Name | Type | | ------------------------------------- | ----- | | @latitude-data/source-manager | Minor | | @latitude-data/sql-compiler | Major | | @latitude-data/server | Patch | | @latitude-data/cli | Patch | | @latitude-data/athena-connector | Patch | | @latitude-data/bigquery-connector | Patch | | @latitude-data/clickhouse-connector | Patch | | @latitude-data/databricks-connector | Patch | | @latitude-data/duckdb-connector | Patch | | @latitude-data/materialized-connector | Patch | | @latitude-data/mssql-connector | Patch | | @latitude-data/mysql-connector | Patch | | @latitude-data/postgresql-connector | Patch | | @latitude-data/snowflake-connector | Patch | | @latitude-data/sqlite-connector | Patch | | @latitude-data/test-connector | Patch | | @latitude-data/trino-connector | Patch |

Not sure what this means? Click here to learn what changesets are.

Click here if you're a maintainer who wants to add another changeset to this PR

latitude-dev / latitude