I've been reading up on string formatting, concatenation, etc in Python and ran into an issue. Given a python object, how come this works in SQLite:
for table in tables:
query = 'PRAGMA table_info(%s);' % table
results = connection.execute(query)
. . .
but this doesn't:
for table in tables:
query = 'PRAGMA table_info({0});'.format(table)
results = connection.execute(query)
Error for the second version:
database error: near "(": syntax error