Add Cloud Spanner and BigQuery support

[StevenACoffman]

What do you want to change?

Just as sqlc supports PostgreSQL dialect, there is a similar binding for ZetaSQL dialect in https://github.com/goccy/go-zetasql

The ZetaSQL dialect is used by both GCP Cloud Spanner and BigQuery.

What database engines need to be changed?

ZetaSQL

What programming language backends need to be changed?

Go

[kyleconroy]

This is a great idea. Unlike a few other engines, ZetaSQL has a full parser that's easy to import. I'll need to play around with it to make sure that it builds on all our supported platforms.

[kyleconroy]

I removed the accepted label as we aren't planning on working on this in the short term. Still excited about it!

[matdurand]

@kyleconroy how hard would you say this is given we could reuse the ZetaSQL parser? I would really like to have Spanner support with SQLc. And would you accept a PR if I have some time to spare on this?

[matdurand]

Hum, I see you're trying to remove CGO dependencies to be able to run on Windows and golang ZetaSQL is a CGO dependency, so this probably won't fly ...

[matdurand]

Here is a potential non CGO replacement for the query parser. It's probably just for Spanner though, not BigQuery
https://github.com/cloudspannerecosystem/memefish