I just changed my code to show `error.cause` <:lul:946531054485930015>
I just changed my code to show 
error.cause 
.cause is standard, unfortunately 
parseInt to get the query to function. Figuring it out through process of elimination is time-consuming and I ended up having to remove bound parameters one by one until I identified which one was causing the issue so that I could trace back why that value was being bound improperly.ALTER TABLE statements released within the week or so.current_timestamp, current_time, and current_date should now work outside of CREATE TABLE statements now:wrangler d1 migrations apply production-y flag (not supported yet). You should be able to echo | wrangler d1 migrations apply <db-name> to non-interactively confirmall()/raw()/first()/etcExecute returned results - did you mean to call query?
table as the name of a column, it fails to delete rows from the UI. I presume it isn't adding ' or " around column names.ALTER TABLE works!
DROP COLUMN supported? It's giving me a not authorized... 
ALTER TABLE did work already 
e68dccd4-7bf7-4860-ba18-17978966ec10

6/12/23, 3:05 PM


parseIntโ wrangler d1 execute db-enam --command "SELECT json_object('hello', 1, 'world', 2, 'foo', 3, 'bar', 4, 'baz', 5, 'quux', 6, 'floop', 7)"
๐ Mapping SQL input into an array of statements
๐ Parsing 1 statements
๐ฃ Executed 1 commands in 0.1332309991121292ms
โโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโ
โ json_object('hello', 1, 'world', 2, 'foo', 3, 'bar', 4, 'baz', 5, 'quux', 6, 'floop', 7) โ
โโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโค
โ {"hello":1,"world":2,"foo":3,"bar":4,"baz":5,"quux":6,"floop":7} โ
โโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโโALTER TABLEALTER TABLEALTER TABLEcurrent_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 COLUMNALTER TABLE <table> DROP COLUMN <column>;
ALTER TABLE <table> DROP <column>;