{"action":"created","issue":{"url":"https://api.github.com/repos/jeremyevans/sequel/issues/1141","repository_url":"https://api.github.com/repos/jeremyevans/sequel","labels_url":"https://api.github.com/repos/jeremyevans/sequel/issues/1141/labels{/name}","comments_url":"https://api.github.com/repos/jeremyevans/sequel/issues/1141/comments","events_url":"https://api.github.com/repos/jeremyevans/sequel/issues/1141/events","html_url":"https://github.com/jeremyevans/sequel/issues/1141","id":131885502,"number":1141,"title":"Malformed ADO Query using Access","user":{"login":"davide-cisco","id":14738751,"avatar_url":"https://avatars.githubusercontent.com/u/14738751?v=3","gravatar_id":"","url":"https://api.github.com/users/davide-cisco","html_url":"https://github.com/davide-cisco","followers_url":"https://api.github.com/users/davide-cisco/followers","following_url":"https://api.github.com/users/davide-cisco/following{/other_user}","gists_url":"https://api.github.com/users/davide-cisco/gists{/gist_id}","starred_url":"https://api.github.com/users/davide-cisco/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/davide-cisco/subscriptions","organizations_url":"https://api.github.com/users/davide-cisco/orgs","repos_url":"https://api.github.com/users/davide-cisco/repos","events_url":"https://api.github.com/users/davide-cisco/events{/privacy}","received_events_url":"https://api.github.com/users/davide-cisco/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":6,"created_at":"2016-02-06T18:36:17Z","updated_at":"2016-02-06T19:30:42Z","closed_at":"2016-02-06T18:52:00Z","body":"Hello,\r\nthe following code produces a query that is not valid for MS Access ADO DB:\r\n\r\n```ruby\r\n    @db = Sequel.ado :conn_string => \"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=source_db_file.mdb\"\r\n    @db[:table].order(:id).select([:id, :field_a, :field_b, :field_n]).sql\r\n````\r\n\r\nHere it is the result:\r\n\r\n```sql\r\n    SELECT ([id], [field_a], [field_b], [field_n]) FROM [table] ORDER BY [id]\r\n```\r\n\r\nThe field list is wrapped by an extra (), not valid in MS Access."},"comment":{"url":"https://api.github.com/repos/jeremyevans/sequel/issues/comments/180843602","html_url":"https://github.com/jeremyevans/sequel/issues/1141#issuecomment-180843602","issue_url":"https://api.github.com/repos/jeremyevans/sequel/issues/1141","id":180843602,"user":{"login":"davide-cisco","id":14738751,"avatar_url":"https://avatars.githubusercontent.com/u/14738751?v=3","gravatar_id":"","url":"https://api.github.com/users/davide-cisco","html_url":"https://github.com/davide-cisco","followers_url":"https://api.github.com/users/davide-cisco/followers","following_url":"https://api.github.com/users/davide-cisco/following{/other_user}","gists_url":"https://api.github.com/users/davide-cisco/gists{/gist_id}","starred_url":"https://api.github.com/users/davide-cisco/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/davide-cisco/subscriptions","organizations_url":"https://api.github.com/users/davide-cisco/orgs","repos_url":"https://api.github.com/users/davide-cisco/repos","events_url":"https://api.github.com/users/davide-cisco/events{/privacy}","received_events_url":"https://api.github.com/users/davide-cisco/received_events","type":"User","site_admin":false},"created_at":"2016-02-06T19:30:42Z","updated_at":"2016-02-06T19:30:42Z","body":"Tanks"}}