feat: support Dollar-Quoted String Constants

[chenzl25]

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：
risingwavelabs/dbt-risingwave#31 (comment)

Describe the solution you'd like

No response

Describe alternatives you've considered

No response

Additional context

No response

[xiangjinwu]

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]

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.