Complete DDL statements support

[apstndb]

(Last updated of DDL statement list: 2024-10-27)

https://cloud.google.com/spanner/docs/reference/standard-sql/data-definition-language

• SCHEMA statements #100 https://github.com/cloudspannerecosystem/memefish/pull/179
  • [x] CREATE SCHEMA
  • [x] DROP SCHEMA
• DATABASE statements
  • [x] CREATE DATABASE
  • [x] ALTER DATABASE https://github.com/cloudspannerecosystem/memefish/pull/161
• PLACEMENT statements #165
  • [ ] CREATE PLACEMENT #194
• PROTO BUNDLE statements #89 #176
  • [x] CREATE PROTO BUNDLE
  • [x] ALTER PROTO BUNDLE
  • [x] DROP PROTO BUNDLE
• TABLE statements
  • [x] CREATE TABLE
  • [x] ALTER TABLE
  • [x] DROP TABLE
  • [x] RENAME TABLE https://github.com/cloudspannerecosystem/memefish/issues/130 https://github.com/cloudspannerecosystem/memefish/pull/170
• INDEX statements
  • [x] CREATE INDEX
  • [x] ALTER INDEX
  • [x] DROP INDEX
• SEARCH INDEX statements https://github.com/cloudspannerecosystem/memefish/issues/108 https://github.com/cloudspannerecosystem/memefish/pull/111
  • [x] CREATE SEARCH INDEX
  • [x] ALTER SEARCH INDEX
  • [x] DROP SEARCH INDEX
• VIEW statements
  • [x] CREATE VIEW and CREATE OR REPLACE VIEW
  • [x] DROP VIEW https://github.com/cloudspannerecosystem/memefish/pull/155
• CHANGE STREAM statements
  • [x] CREATE CHANGE STREAM
  • [x] ALTER CHANGE STREAM
  • [x] DROP CHANGE STREAM
• ROLE statements
  • [x] GRANT
  • [x] REVOKE
• SEQUENCE statements
  • [x] CREATE SEQUENCE
  • [x] ALTER SEQUENCE
  • [x] DROP SEQUENCE
• STATISTICS statements
  • [x] ALTER STATISTICS https://github.com/cloudspannerecosystem/memefish/pull/163
  • [x] ANALYZE #93
• MODEL statements #96 #195
  • [ ] CREATE MODEL and CREATE OR REPLACE MODEL
  • [ ] ALTER MODEL
  • [ ] DROP MODEL
• VECTOR INDEX statements
  • [x] CREATE VECTOR INDEX
  • [x] DROP VECTOR INDEX

https://cloud.google.com/spanner/docs/reference/standard-sql/graph-schema-statements

• PROPERTY GRAPH statements #98 #101
  • [ ] CREATE PROPERTY GRAPH
  • [ ] DROP PROPERTY GRAPH