[Feature] Support Continuous SQL Queries in dbt

[dpguthrie]

Is this your first time submitting a feature request?

• [X] I have read the expectations for open source contributors
• [X] I have searched the existing issues, and I could not find an existing issue for this feature
• [X] I am requesting a straightforward extension of existing dbt-bigquery functionality, rather than a Big Idea better suited to a discussion

Describe the feature

BigQuery now helps make real-time streaming data processing easy with new support for continuous SQL queries, an unbounded SQL query that processes data the moment it arrives via SQL statement.

Describe alternatives you've considered

No response

Who will this benefit?

Anyone using bigquery and wanting to tackle streaming use cases with SQL!

Are you interested in contributing this feature?

No

Anything else?

https://cloud.google.com/bigquery/docs/continuous-queries-introduction#:~:text=BigQuery%20continuous%20queries%20are%20SQL,to%20Pub%2FSub%20or%20Bigtable.

[amychen1776]

I would love to be able to do this but unfortunately at this time we do not have capacity on our roadmap. That said, I'm going to leave this issue up to collect information