sql: add support for HTTP(s) connections

[awoods187]

CockroachDB does not support database connections across HTTP(S). All database connections must be made via TCP. This is a tracking issue for adding support for HTTP connections.

We may pursue this in a variety of ways including #69010

[rafiss]

Is the intention to support sending SQL commands in an HTTP request body? This issue needs more details in the main description body.

[knz]

Is this an issue redundant with the PostGREST project?
cc @nvanbenschoten

Also I don't understand why this is assigned to the server team

[otan]

i don't think the tech note really in the docs as a limitation makes sense either?

https://github.com/cockroachdb/docs/pull/11083/files#r717039281

What brought this issue on? It doesn't seem like something we want anyway (or least, not something that should be expected would block someone enough such that i'd classify it as a "limitation" in the docs) and want a third party (e.g. PostgREST) to support it.

[rafiss]

@awoods187 Is this referring to something like the Aurora Data API? https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/data-api.html

I agree that the tech note as written needs to be clarified

[awoods187]

We can close this for now give the progress on PostgREST-- I was merely noting that PostgREST is only one way we could solve this need (we could also build our own connection like FaunaDB for example).