You can't do that in SQLite on purpose. Preparing a SQL statement requires that SQLite be able to build a query plan, and it can't do that if it doesn't know what tables and columns to operate over. If you need SQL queries to vary beyond that, you build the query string in your calling code and prepare each version in turn.