I thought that the quotation mark (") was simply a type of grouping marker but I'm debugging some NHibernate code and notice that while
SELECT * FROM site WHERE site_id = 3;
Works fine
SELECT * FROM "site" WHERE site_id = 3;
fails with a table or view does not exist error.
What gives?