SQLite Forum

trying to select one column from one table
As to why it's not giving you an error, it's because [double quoted string literals are accepted](https://www.sqlite.org/quirks.html#double_quoted_string_literals_are_accepted)

Despite using double quotes, since there is no column named "Interior" it says "well, I guess you meant that as a string literal", and returns it as a string literal.