{"action":"created","issue":{"url":"https://api.github.com/repos/korma/Korma/issues/285","labels_url":"https://api.github.com/repos/korma/Korma/issues/285/labels{/name}","comments_url":"https://api.github.com/repos/korma/Korma/issues/285/comments","events_url":"https://api.github.com/repos/korma/Korma/issues/285/events","html_url":"https://github.com/korma/Korma/issues/285","id":60521310,"number":285,"title":"generated sql contains \"double-quotes\" around everything for Oracle DB?","user":{"login":"sbitteker","id":5445897,"avatar_url":"https://avatars.githubusercontent.com/u/5445897?v=3","gravatar_id":"","url":"https://api.github.com/users/sbitteker","html_url":"https://github.com/sbitteker","followers_url":"https://api.github.com/users/sbitteker/followers","following_url":"https://api.github.com/users/sbitteker/following{/other_user}","gists_url":"https://api.github.com/users/sbitteker/gists{/gist_id}","starred_url":"https://api.github.com/users/sbitteker/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sbitteker/subscriptions","organizations_url":"https://api.github.com/users/sbitteker/orgs","repos_url":"https://api.github.com/users/sbitteker/repos","events_url":"https://api.github.com/users/sbitteker/events{/privacy}","received_events_url":"https://api.github.com/users/sbitteker/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":2,"created_at":"2015-03-10T15:49:33Z","updated_at":"2015-03-10T16:37:38Z","closed_at":null,"body":"Just trying out Korma for the first time. I had a BoneCP pool that I'm using, if it makes any difference.\r\nThe query generated is correct for Oracle 11g, if I paste it into a query tool and remove all the double-quotes. When running in the REPL I get a  ```Message: ORA-00904: \"TEAM_NOTES\".\"note_type_id\": invalid identifier.``` If it generated without the quotes it would work. i.e.```TEAM_NOTES.note_type_id```\r\nBut every table and column name has double quotes around them,\r\n\r\nSince I'm not using the included C3PO, is there a (Oracle) dialect or something else I need to set to prevent the double quotes form being generated?\r\n\r\nThanks,\r\nSteve"},"comment":{"url":"https://api.github.com/repos/korma/Korma/issues/comments/78093353","html_url":"https://github.com/korma/Korma/issues/285#issuecomment-78093353","issue_url":"https://api.github.com/repos/korma/Korma/issues/285","id":78093353,"user":{"login":"sbitteker","id":5445897,"avatar_url":"https://avatars.githubusercontent.com/u/5445897?v=3","gravatar_id":"","url":"https://api.github.com/users/sbitteker","html_url":"https://github.com/sbitteker","followers_url":"https://api.github.com/users/sbitteker/followers","following_url":"https://api.github.com/users/sbitteker/following{/other_user}","gists_url":"https://api.github.com/users/sbitteker/gists{/gist_id}","starred_url":"https://api.github.com/users/sbitteker/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sbitteker/subscriptions","organizations_url":"https://api.github.com/users/sbitteker/orgs","repos_url":"https://api.github.com/users/sbitteker/repos","events_url":"https://api.github.com/users/sbitteker/events{/privacy}","received_events_url":"https://api.github.com/users/sbitteker/received_events","type":"User","site_admin":false},"created_at":"2015-03-10T16:37:38Z","updated_at":"2015-03-10T16:37:38Z","body":"I'm not sure what you mean. I don't have any \"quoted strings\" at all.\r\n\r\n(defentity ntype\r\n  (pk :TYPE_ID)\r\n  (belongs-to pnotes {:fk :TYPE_ID})\r\n  (many-to-many ntype :NOTE_TYPE { :rfk :TYPE_ID})\r\n  (table :NOTE_TYPE))\r\n  \r\n(defentity ngroup\r\n  (pk :GROUP_ID)\r\n  (belongs-to pnotes {:fk :GROUP_ID})\r\n  (many-to-many ngroup :NOTE_GROUP { :rfk :GROUP_ID})\r\n  (table :NOTE_GROUP))\r\n\r\n(defentity pnotes\r\n  (pk :NOTE_ID)\r\n  (table :NOTES)\r\n  (belongs-to ntype {:fk :TYPE_ID})\r\n  (belongs-to ngroup {:fk :GROUP_ID}))\r\n  \r\n  \r\n\r\n(select pnotes)  --korma retuns ()   -- from a query tool. select * from notes  => returns 5 rows\r\n(select pnotes (with ntype) (with ngroup))  =>  ORA-00904: \"NOTES\".\"TYPE_ID\": invalid identifier\r\n\r\nThe query korma generates is..\r\nSELECT \"NOTES\".*, \"NOTE_TYPE\".*, \"NOTE_GROUP\".* \r\nFROM (\"NOTES\" LEFT JOIN \"NOTE_TYPE\" ON \"NOTE_TYPE\".\"TYPE_ID\" = \"NOTES\".\"TYPE_ID\") \r\nLEFT JOIN \"NOTE_GROUP\" ON \"NOTE_GROUP\".\"GROUP_ID\" = \"NOTES\".\"GROUP_ID\"\r\n\r\nIf I change all defentity's to lower case (i.e. table name and column keywords, etc.) it still generates the same query as above only all is lowercase with the same double-quotes.\r\n\r\nOracle doesn't like the Quotes around column and table names. Korma shouldn't create the query with double quotes around everything. How to configure Korma to remove them?"}}