search

goccy / go-zetasqlite

A database driver library that interprets ZetaSQL queries and runs them using SQLite3
MIT License
56 stars 29 forks source link

FEAT: ALTER TABLE support #113

Open StevenACoffman opened 1 year ago

StevenACoffman commented 1 year ago

Currently adding support for BigQuery to golang-migrate is hampered by an inability to test DDL functionality in a Go emulator. This would just require support for a subset of ALTER TABLE such as:

ALTER TABLE products ADD COLUMN price DECIMAL;
ALTER TABLE products DROP COLUMN price;

See https://github.com/golang-migrate/migrate/pull/881

goccy commented 1 year ago

@StevenACoffman Thank you for your reporting. Currently, I'm looking into supporting DDL. I plan to start with the ALTER statement. 👍

myhau commented 5 months ago

Hello @StevenACoffman, @goccy :)

Have you made some progress on this issue?

I'm asking as I started tinkering with with implementation (it's needed to support table modification in bigquery emulator), but maybe you already have some "prototype" that works locally?