feat: support Dollar-Quoted String Constants

risingwavelabs / risingwave

Best-in-class stream processing, analytics, and management. Perform continuous analytics, or build event-driven applications, real-time ETL pipelines, and feature stores in minutes. Unified streaming and batch. PostgreSQL compatible.

https://go.risingwave.com/slack

Apache License 2.0

6.84k stars 568 forks source link

feat: support Dollar-Quoted String Constants #14763

Open chenzl25 opened 8 months ago

chenzl25 commented 8 months ago

Is your feature request related to a problem? Please describe.

PostgreSQL Dollar-Quoted String Constants https://www.postgresql.org/docs/current/sql-syntax-lexical.html#SQL-SYNTAX-DOLLAR-QUOTING

DBT persist doc feature relies on this feature as well： https://github.com/risingwavelabs/dbt-risingwave/issues/31#issue-2092520204

Describe the solution you'd like

No response

Describe alternatives you've considered

No response

Additional context

No response

xiangjinwu commented 8 months ago

It is already supported at sqlparser layer with a bug #14504 (inherited from upstream), we just need to fix it and bind it to a string literal.

github-actions[bot] commented 3 months ago

This issue has been open for 60 days with no activity. Could you please update the status? Feel free to continue discussion or close as not planned.