> sqlite 3.7.8 on MacOS X
> This query works fine:
> SELECT rowid, * FROM 'customer' WHERE rowid < 100;
> While this query does not return anything:
> SELECT rowid, * FROM 'customer' WHERE 'rowid' < 100;
> Do you have an explanation?
perhaps because in the second query 'rowid' is being treated as a string and not a column. You might want to try "rowid" instead (double quotes).