spanner/spansql: What is the current status of spansql?

[apstndb]

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

[apstndb]

There has been no response from the owner, but memefish, a community-based Spanner GoogleSQL parser, is increasing its coverage daily. A recent milestone achieved is the implementation of all kinds of DDL, including CREATE PROPERTY GRAPH.

• Complete DDL statements support cloudspannerecosystem/memefish#178

Developers experiencing issues with spansql are encouraged to try memefish.

[apstndb]

@harshachinta

Any answers?
At least it doesn't seem like issues are going to be resolved by Google's client library team. How about you write the current status in the README.md in the spansql directory?

[apstndb]

👀

• chore(spanner/spansql): update readme of spansql and spannertest package about maintenance status #11941