I saw a similar question in Stack Overflow pertaining to Android, but I was wondering whether I should use backticks (`) or double quotes (") - using Python - to select table names or rowid or what have you.
I tried single quotes - like this select 'rowid', * from 'tbl' order by 'rowid'. The single quotes worked in some cases but not all. I learned to use double quotes or backticks, and I was looking at SQLite Database Browser and I noticed that it used backticks.
I really like to put double quotes around my strings in Python because I'm coming from Java, so it is natural to do cursor.execute("select 'rowid',* from 'table';"), and it would be just as easy to do backticks (the double quotes would require a backslash and make the query look a little confusing). However, I just wanted to make sure that the backticks are portable (all versions of Windows, Linux, Os x, etc.).
"select 'rowid', * from table;"I got('rowid', name,...). As laalto just posted - "Single quotes are for string literals, not identifiers." - dylnmc