ALTER TABLE statements released within the week or so.ALTER TABLE
M
current_timestamp, current_time, and current_date should now work outside of CREATE TABLE statements now:
I
I
I
wrangler d1 migrations apply productionM
-y flag (not supported yet). You should be able to echo | wrangler d1 migrations apply <db-name> to non-interactively confirmII
MM
Kall()/raw()/first()/etcKExecute returned results - did you mean to call query?
Itable as the name of a column, it fails to delete rows from the UI. I presume it isn't adding ' or " around column names.I
MMMI
ALTER TABLE
IDROP COLUMN supported? It's giving me a not authorized... 
K
IMMI
ALTER TABLE
GM
M
e68dccd4-7bf7-4860-ba18-17978966ec10M
UU
)M
J
6/12/23, 3:05 PM
J
C
CJCCM
R
success: true on UPDATE 
is that on purpose?U
URMMM
current_timestampcurrent_timecurrent_dateCREATE TABLE➜ wrangler d1 execute db-enam --command "SELECT current_timestamp, current_time, current_date" --json | jq '.[].results'
[
{
"current_timestamp": "2023-06-09 16:16:37",
"current_time": "16:16:37",
"current_date": "2023-06-09"
}
]wrangler d1 migrations apply production-yecho | wrangler d1 migrations apply <db-name>all()raw()first()table'"DROP COLUMNe68dccd4-7bf7-4860-ba18-17978966ec10success: trueALTER TABLE <table> DROP COLUMN <column>;
ALTER TABLE <table> DROP <column>;