{"action":"closed","issue":{"url":"https://api.github.com/repos/Raizlabs/DBFlow/issues/193","labels_url":"https://api.github.com/repos/Raizlabs/DBFlow/issues/193/labels{/name}","comments_url":"https://api.github.com/repos/Raizlabs/DBFlow/issues/193/comments","events_url":"https://api.github.com/repos/Raizlabs/DBFlow/issues/193/events","html_url":"https://github.com/Raizlabs/DBFlow/issues/193","id":67772941,"number":193,"title":"improperly generated backticks in select query","user":{"login":"mayur-mi","id":6574267,"avatar_url":"https://avatars.githubusercontent.com/u/6574267?v=3","gravatar_id":"","url":"https://api.github.com/users/mayur-mi","html_url":"https://github.com/mayur-mi","followers_url":"https://api.github.com/users/mayur-mi/followers","following_url":"https://api.github.com/users/mayur-mi/following{/other_user}","gists_url":"https://api.github.com/users/mayur-mi/gists{/gist_id}","starred_url":"https://api.github.com/users/mayur-mi/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mayur-mi/subscriptions","organizations_url":"https://api.github.com/users/mayur-mi/orgs","repos_url":"https://api.github.com/users/mayur-mi/repos","events_url":"https://api.github.com/users/mayur-mi/events{/privacy}","received_events_url":"https://api.github.com/users/mayur-mi/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":{"url":"https://api.github.com/repos/Raizlabs/DBFlow/milestones/6","html_url":"https://github.com/Raizlabs/DBFlow/milestones/2.0.0","labels_url":"https://api.github.com/repos/Raizlabs/DBFlow/milestones/6/labels","id":987037,"number":6,"title":"2.0.0","description":null,"creator":{"login":"agrosner","id":2117859,"avatar_url":"https://avatars.githubusercontent.com/u/2117859?v=3","gravatar_id":"","url":"https://api.github.com/users/agrosner","html_url":"https://github.com/agrosner","followers_url":"https://api.github.com/users/agrosner/followers","following_url":"https://api.github.com/users/agrosner/following{/other_user}","gists_url":"https://api.github.com/users/agrosner/gists{/gist_id}","starred_url":"https://api.github.com/users/agrosner/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/agrosner/subscriptions","organizations_url":"https://api.github.com/users/agrosner/orgs","repos_url":"https://api.github.com/users/agrosner/repos","events_url":"https://api.github.com/users/agrosner/events{/privacy}","received_events_url":"https://api.github.com/users/agrosner/received_events","type":"User","site_admin":false},"open_issues":23,"closed_issues":1,"state":"open","created_at":"2015-02-19T16:57:43Z","updated_at":"2015-05-02T14:40:29Z","due_on":null,"closed_at":null},"comments":5,"created_at":"2015-04-11T11:03:43Z","updated_at":"2015-05-02T14:40:29Z","closed_at":"2015-05-02T14:40:29Z","body":"recently, i have been playing with dbflow and i realized that when querying data from multiple tables, using the query like \r\n\r\nnew Select(\"t1.col1, t1.col2, t2.col1\")\r\n.from(Table1.class).as(\"t1\")\r\n.join(Table2.class,Join.JoinType.INNER).as(\"t2\")\r\n.on(Condition.column(\"t1.\" + TestModel1$Table.ID).eq(\"t2.\" + TestModel1$Table.ID))\r\n.querySingle();\r\n\r\nThe generated query was having problems in backticks in the select statement's column lists.\r\n\r\nMay be you need to fix the function generating these backticks in the sql."}}