CockroachDB: Basic query support

[plcplc]

Our initial support for v22.1 CockroachDB should include just that of running basic queries.

The scope of this is that a user should be able to, via the console:

1. Add a cockroachdb source on a page branded as such.
2. Create and track tables
3. Run a graphql query that exercises filters and aggregations.

The following are excluded from the scope of basic queries and can be implemented afterwards:

1. Track object and array relationships
2. Set query permissions
3. Run a graphql query that exercises relationships.

In order for the GraphQL-Engine to be able to support this, the following gaps need to be closed (to be made into separate issues):

General infrastructure:

• Server/Tests: Integrate CockroachDB in test harness and CI #8789
• Server/Tests: Introduce CockroachDB Simple Query tests #8839
• server/tests: enable cockroachdb in the pytest suite #8891

On the server side:

• server/cockroachdb: Define a new Postgres variant boilerplate #8790
• server/cockroachdb: add cockroachdb_table_metadata.sql #8800
• hasura/graphql-engine-mono#5593
• pg-client-hs must support jsonb type binary format #8791
• disable fetchFunctionMetadata for cockroachdb #8840
• Server: Deal with lack of support for custom SET LOCAL options #8797
• Server/CockroachDB: Verify Metadata API for CockroachDB #8799
• Server: Strict usage of prepared arguments #8792
• Server: GraphQL API error with CockroachDB #8890

On the console side:

• Console/Server: Define a new Postgres variant boilerplate #8793
• Console: Integrate CockroachDB and disable Raw SQL #8794
• hasura/graphql-engine-mono#5567

Docs:

• cockroachdb/docs: schema #9021
• cockroachdb/docs: queries #9018

Incoming support/fixes from CRDB team (in rough priority order):

• sql: Different handling of prepared statement arguments compared to Postgresql cockroachdb/cockroach#86375
• sql: support #typeHints greater than #placeholders for prepare stmt cockroachdb/cockroach#87535
• sql: is_generated from information schema values are inconsistent with PostgreSQL cockroachdb/cockroach#87481
• Server: Functions/views missing in CockroachDB #8821
• https://github.com/hasura/graphql-engine-mono/issues/5984
• pg_catalog.col_description is very slow cockroachdb/cockroach#87947
• sql: support for SELECT with no projections cockroachdb/cockroach#83255

[sassela]

just added #8891 to this list, which we'll estimate later

[sassela]

Released in v2.15.0! Closing