current_timestamp, current_time, and current_date should now work outside of CREATE TABLE statements now: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"
}
]
I
I
I
wrangler d1 migrations apply production
M
-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 works! 
IDROP COLUMN supported? It's giving me a not authorized... 
K
IMMI
ALTER TABLE did work already 
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
URMMMR
wrangler d1 migrations apply production-yecho | wrangler d1 migrations apply <db-name>all()raw()first()table'"ALTER TABLEALTER TABLEDROP COLUMNe68dccd4-7bf7-4860-ba18-17978966ec10success: trueALTER TABLE <table> DROP COLUMN <column>;
ALTER TABLE <table> DROP <column>;