[feat] add preview sql interface

[liangriyu]

What is this PR?

This is a:

• [ ] documentation update
• [ ] bug fix with no breaking changes
• [x] new functionality
• [ ] a breaking change

All pull requests from community contributors should target the main branch (default).

Description & motivation

Checklist

• [x] I have verified that these changes work locally on the following warehouses (Note: it's okay if you do not have access to all warehouses, this helps us understand what has been covered)
  • [ ] BigQuery
  • [x] Postgres
  • [ ] Redshift
  • [ ] Snowflake
  • [ ] Databricks
  • [ ] Spark
• [ ] I have updated the README.md (if applicable)
• [x] I have added tests & descriptions to my models
• [ ] I have added an entry to CHANGELOG.md

[cla-bot[bot]]

Thanks for your pull request, and welcome to our community! We require contributors to sign our Contributor License Agreement and we don't seem to have your signature on file. Check out this article for more information on why we have a CLA.

In order for us to review and merge your code, please submit the Individual Contributor License Agreement form attached above above. If you have questions about the CLA, or if you believe you've received this message in error, please reach out through a comment on this PR.

CLA has not been signed by users: @liangriyu