[Ideas] Official JDBC/ODBC driver required #1705

Hi @cleverxiao001,

Thanks for raising this — recognizing Cloudberry-specific syntax like DISTRIBUTED BY and ORIENTATION in metadata is genuinely useful for tooling and query optimization, so this is a fair ask.

Just to share what I found while looking into it: there is an existing repo at cloudberry-contrib/jdbc that seems intended as a home for a Cloudberry JDBC driver. However, in its current state it appears to be a straight mirror of upstream pgjdbc — the README is unchanged from PgJDBC, a code search for cloudberry or DISTRIBUTED returns no hits, and the most recent commits (latest dated 2024年12月12日) all look like upstream syncs. So as it stands today, it would not behave any differently from the stock PostgreSQL driver for the cases you described.

That said, the repo could be a great starting point if the community wants to build a proper Cloudberry-aware driver on top of it (extended DatabaseMetaData, DDL reverse-engineering that preserves distribution/storage clauses, etc.). Since you mentioned you would be willing to submit a PR, it might be worth checking with the maintainers whether cloudberry-contrib/jdbc is the intended landing spot for that work, or whether a new official driver effort should be kicked off here.

Happy to help think through what the metadata extensions might look like if it is useful.