[Feature Request]: Use bigquery calcite dialect

[flo076]

What would you like to happen?

Hello,
I’m currently migrating from ZetaSQL to Calcite within an Apache Beam pipeline.

To support certain transformations that are only available with the BigQuery dialect, I understand that the JDBC connection must be configured with fun=bigquery.

However, the BeamSqlPipelineOptions class does not appear to provide a way to configure the Calcite connection URL or dialect.
Thanks.

Issue Priority

Priority: 2 (default / most feature requests should be filed as P2)

Issue Components

• Component: Python SDK
• Component: Java SDK
• Component: Go SDK
• Component: Typescript SDK
• Component: IO connector
• Component: Beam YAML
• Component: Beam examples
• Component: Beam playground
• Component: Beam katas
• Component: Website
• Component: Infrastructure
• Component: Spark Runner
• Component: Flink Runner
• Component: Samza Runner
• Component: Twister2 Runner
• Component: Hazelcast Jet Runner
• Component: Google Cloud Dataflow Runner