Tracking: support integration with Sqlmesh

[lmatz]

Please push the code to https://github.com/risingwavelabs/sqlmesh for now. Later, we'll see if we can contribute back to the upstream.

• [ ]

[lmatz]

Please use Sqlmesh's Postgres adapter to connect to RW and run all kinds of tests,
to check the error message in RW whenever it fails. And then solve each error, e.g. support missing catalogs etc in RW, one after another.

[lin0303-siyuan]

See latest codes in branch feature/rw_adapter in repo https://github.com/risingwavelabs/sqlmesh. There are some issues with the adapter yet: fetchdf from full models return empty dataframe, which is supposed to contain data.

The guide can be referred from https://www.notion.so/risingwave-labs/Sqlmesh-Support-on-RW-bdcac801622546ce8af370ad4674f1c1?pvs=4.

[github-actions]

This issue has been open for 60 days with no activity.

If you think it is still relevant today, and needs to be done in the near future, you can comment to update the status, or just manually remove the no-issue-activity label.

You can also confidently close this issue as not planned to keep our backlog clean.
Don't worry if you think the issue is still valuable to continue in the future.
It's searchable and can be reopened when it's time. 😄