{"action":"created","issue":{"url":"https://api.github.com/repos/sgrif/diesel/issues/194","repository_url":"https://api.github.com/repos/sgrif/diesel","labels_url":"https://api.github.com/repos/sgrif/diesel/issues/194/labels{/name}","comments_url":"https://api.github.com/repos/sgrif/diesel/issues/194/comments","events_url":"https://api.github.com/repos/sgrif/diesel/issues/194/events","html_url":"https://github.com/sgrif/diesel/pull/194","id":131742276,"number":194,"title":"Support subselects for IN statements.","user":{"login":"sgrif","id":1529387,"avatar_url":"https://avatars.githubusercontent.com/u/1529387?v=3","gravatar_id":"","url":"https://api.github.com/users/sgrif","html_url":"https://github.com/sgrif","followers_url":"https://api.github.com/users/sgrif/followers","following_url":"https://api.github.com/users/sgrif/following{/other_user}","gists_url":"https://api.github.com/users/sgrif/gists{/gist_id}","starred_url":"https://api.github.com/users/sgrif/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sgrif/subscriptions","organizations_url":"https://api.github.com/users/sgrif/orgs","repos_url":"https://api.github.com/users/sgrif/repos","events_url":"https://api.github.com/users/sgrif/events{/privacy}","received_events_url":"https://api.github.com/users/sgrif/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":2,"created_at":"2016-02-05T20:03:01Z","updated_at":"2016-02-05T20:12:54Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/sgrif/diesel/pulls/194","html_url":"https://github.com/sgrif/diesel/pull/194","diff_url":"https://github.com/sgrif/diesel/pull/194.diff","patch_url":"https://github.com/sgrif/diesel/pull/194.patch"},"body":"This is a feature that was supported by `eq(any())`, but not currently\r\nby the in clause. The `Subselect` type was introduced to normalize the\r\ndifferences between the SQL type of `SelectStatement` depending on the\r\nbackend. That implementation is a bit of a wart, regardless. We can\r\nprobably revisit this later and factor out some kind of a `Many` SQL\r\ntype which is independent of `Array`. I need to better analyze the\r\nimpact of that change though, (specifically making sure that it\r\ncontinues to work with `eq(any())`), and I think it's out of scope for\r\n0.5."},"comment":{"url":"https://api.github.com/repos/sgrif/diesel/issues/comments/180538537","html_url":"https://github.com/sgrif/diesel/pull/194#issuecomment-180538537","issue_url":"https://api.github.com/repos/sgrif/diesel/issues/194","id":180538537,"user":{"login":"mfpiccolo","id":3249825,"avatar_url":"https://avatars.githubusercontent.com/u/3249825?v=3","gravatar_id":"","url":"https://api.github.com/users/mfpiccolo","html_url":"https://github.com/mfpiccolo","followers_url":"https://api.github.com/users/mfpiccolo/followers","following_url":"https://api.github.com/users/mfpiccolo/following{/other_user}","gists_url":"https://api.github.com/users/mfpiccolo/gists{/gist_id}","starred_url":"https://api.github.com/users/mfpiccolo/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mfpiccolo/subscriptions","organizations_url":"https://api.github.com/users/mfpiccolo/orgs","repos_url":"https://api.github.com/users/mfpiccolo/repos","events_url":"https://api.github.com/users/mfpiccolo/events{/privacy}","received_events_url":"https://api.github.com/users/mfpiccolo/received_events","type":"User","site_admin":false},"created_at":"2016-02-05T20:12:54Z","updated_at":"2016-02-05T20:12:54Z","body":"Agreed :+1: "}}