SQLite Forum

'values' with no args : has to be syntax error?
Login
> `VALUES(); -- one row, zero columns `

Those semantics are incompatible with how generic APIs which accept arbitrary SQL work: they prepare their SQL then ask if it has any result columns. If it does, it's a SELECT-ike statement (and therefore may generate output), otherwise it's not. Adding select-like statements which have no result columns would break all software which relies on that property.