SQLite Forum

For a given SQL query, mechanisms for figuring out which physical columns would be returned?
Login
Can't solve your problem, but how would you expect whatever solution results to respond to

<code>SELECT age-1 FROM members</code>

or

<code>SELECT 365*20 FROM members</code>

or

<code>SELECT invoice.purch_amount * items.price
    FROM invoice JOIN items ON item.id = invoice.item</code>