I understood that the client library team considered to freeze spansql package.

#5837 (comment)

spansql/spannertest packages lag behind compared to the actualy cloud spanner feature wise and functionality wise, We are thinking of freezing the development of spansql/spannertest packages and recommend to use officially supported https://cloud.google.com/spanner/docs/emulator for in-memory usage.

What is the current status of spansql?

Open Issues

There is no spansql label, but I can find many open issues.

• spanner/spansql: Support subselect and maybe other limitations for spansql parser #8519
• spanner/spansql: add support for ARRAY_FILTER, ARRAY_INCLUDES and ARRAY_TRANSFORM #8768
• spanner/spansql: ON DELETE NO ACTION gets added when no foreign key action is specified #8955
• spanner/spansql: spansql.ParseDDL is fialing on a valid query syntax #9622
• spansql : can't parse normalize function in golang #9768
• spanner: parse TOKENLIST data type failed. #10651
• spanner: spansql.ParseDDL support for ARRAY<FLOAT32> #11106
• spanner :spansql.ParseDLL unable to parse ddl of cloudspanner : columns with types ARRAY<STRING(20)> #11203
• spanner: spansql.ParseDLL gives error got "GENERATED", want ")" or "," #11442
• spanner: spansql.ParseDLL error by parsing text search features in cloudspanner #11466
• spanner: add support for named schema #11560
• spanner: spansql.ParseDLL error by parsing String functions DDL #11685

As far as I know, issues like these relating to spansql are never resolved by the owner, but it seems that PRs from the community are accepted.

There are PRs which are not yet merged.

• feat(spanner/spansql): Add tests and parser support for THEN RETURN #6515
• feat(spanner/spansql): add support for ARRAY_FILTER, ARRAY_INCLUDES and ARRAY_TRANSFORM #8769
• feat(spanner/spansql): respect unspecified foreign key actions in constraints #10121
• feat(spanner/spansql): Add support for DROP SEARCH INDEX and ALTER SEARCH INDEX #11961

FYI

• cloudspannerecosystem/memefish achieved to pass all TestSQL() tests in spansql. Pass all SQL test in spansql tests cloudspannerecosystem/memefish#115
• I am trying to migrate have migrated some ecosystem tools from spansql.
  • [v2] Migrate to memefish cloudspannerecosystem/yo#145
  • Migrate to memefish cloudspannerecosystem/wrench#121
• Some notable OSSs are migrating.
  • feature(spanner): Implement DML Support for Spanner golang-migrate/migrate#1197
  • Migrate from spansql to memefish daichirata/hammer#66