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