M
I
U
HUMHM
created_atusersSELECT * FROM users WHERE created_at = ?1 - that will use the index to look up the rows in the usersuserscreated_atusers
MSELECT * FROM table LIMIT N - yes. But if you have a filter like a WHEREHAVING clause, then you have to scan more rows to match the filter, since your table isn't necessarily ordered.U
MORDER in that query. But it has to scan the table somehow - usually a binary search. It's going to keep searching (scanning) until it has matched all possible records, or hit the LIMITUUMLIMIT 10M
MORDER BY <some_date_column> queries. I probably need to add this to the docs.M
U
H
CSQL LIKE? M
M
T
rows_written and rows_read and I am kinda surprised to find written rows in a SELECT queryTMU
MH
J
KJJJJT
rows_written and rows_read in every result, could we imagine some total_rows_written and total_rows_read in a "status" request?MMMTJC
back from pushing the limits over 500MB? 
C
.batch() it gets auto transactionWhile in the Open Alpha period, there is a possibility of breaking changes. The Alpha is meant for testing purposes and using it for production traffic is not recommended.SELECT * FROM users WHERE created_at = ?1SELECT * FROM table LIMIT NHAVING➜ wrangler d1 execute db-wnam --command "SELECT * FROM [Order] WHERE ShipRegion LIKE '%Western%' LIMIT 10" --json | jq '.[].meta.rows_read'
18 <-- we had to scan 18 rows to find 10 that matched our filterORDERLIMITLIMIT 10ORDER BY <some_date_column>SQL LIKErows_writtenrows_writtenrows_readrows_readtotal_rows_writtentotal_rows_read.batch()