BREAKING CHANGE: Relative queries

[andresgutgon]

Describe your changes

Until now we were requiring users to specify the queries in the ref function from the root of the source folder. Example:

MY_QUERIES
  - my-source
    - source.yml
    - query.sql
    - another_query.sql

Given that folder structure in query.sql

Before 🚫

-- MY_QUERIES/my-source/query.sql
SELECT * FROM {ref('my-source/another_query')}

Now ✅

-- MY_QUERIES/my-source/query.sql
SELECT * FROM {ref('./another_query')}

Or ✅

-- MY_QUERIES/my-source/query.sql
SELECT * FROM {ref('another_query')}

Or ✅

-- MY_QUERIES/my-source/query.sql
SELECT * FROM {ref('/my-source/another_query')}

Issue ticket number and link

https://github.com/latitude-dev/latitude/issues/369

Dependency

https://github.com/latitude-dev/latitude/pull/414/files

TODO

• [x] Pass SQL content from query file from source to connector
• [x] Include in the context request that SQL text
• [x] Fix runQuery 🐛. I introduced the bug here
• [x] Use in ref method the SQL
• [x] Fix tests
• [x] QA is working the changes
• [x] Do Changeset

[changeset-bot[bot]]

🦋 Changeset detected

Latest commit: 8a6b394c83adf4f31bbc0482d4aa162a6315df10

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

This PR includes changesets to release 16 packages

| Name | Type | | ----------------------------------- | ----- | | @latitude-data/source-manager | Major | | @latitude-data/server | Major | | @latitude-data/sql-compiler | 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/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