sql: Hibernate should work with CockroachDB

[nvanbenschoten]

Hibernate currently works to a certain degree with Cockroach, but it breaks down when it attempts to use the Postgres JDBC driver to perform complicated metadata reflection. We should get it fully working.

Blocking Issues:

• sql: Implement pg_catalog.pg_type as a virtual table #10072 (pg_type)
• sql: Implement pg_catalog.pg_am as a virtual table #10073 (pg_am)
• sql: Implement pg_catalog.pg_description as a virtual table #10074 (pg_description)
• sql: Implement pg_catalog.pg_proc as a virtual table #10075 (pg_proc)
• sql: Implement pg_catalog.pg_database as a virtual table #10076 (pg_database)
• sql: Implement pg_catalog.pg_roles as a virtual table #10077 (pg_roles)
• sql: Implement pg_catalog.pg_settings as a virtual table #10078 (pg_settings)
• sql: Implement pg_catalog.pg_index as a virtual table #10416 (pg_index)
• sql: Implement pg_catalog.pg_depend as a virtual table #10521 (pg_depend)
• sql: Fully support Postgres-style Object Identifier Types #9990 (full support for OIDs)
• sql: ensure that common implicit cross joins don't explode #10633 (ensure that common implicit cross-joins don't explode)
  Non-Blocking Issues:
• sql: Identifiers should always be case-folded unless double quoted #8862

[cuongdo]

Thanks for filing these issues @nvanbenschoten. Would you mind indicating which ones are appropriate for SQL newbie / starter projects?

[nvanbenschoten]

All of the blocking issues should be appropriate for people new to SQL. The non-blocking issues are both a little larger in scope, and will require a deeper understanding of the SQL code.

[a6802739]

@nvanbenschoten, maybe I could fix some blocking Issues :)

[nvanbenschoten]

@a6802739 Would you want to try tackling #10078?

[a6802739]

@nvanbenschoten, yeah, I would like to do that.

[nexthack]

@nvanbenschoten I would like to work on one issue among these.Could you let me know any one unless these issues are complex for a beginner into cockroachdb.

[cuongdo]

This works now, with docs and a CI test in examples-orms