{"action":"closed","issue":{"url":"https://api.github.com/repos/MoonStorm/Dapper.FastCRUD/issues/18","labels_url":"https://api.github.com/repos/MoonStorm/Dapper.FastCRUD/issues/18/labels{/name}","comments_url":"https://api.github.com/repos/MoonStorm/Dapper.FastCRUD/issues/18/comments","events_url":"https://api.github.com/repos/MoonStorm/Dapper.FastCRUD/issues/18/events","html_url":"https://github.com/MoonStorm/Dapper.FastCRUD/issues/18","id":118491066,"number":18,"title":"IStandardSqlStatementOptionsBuilder there is no way to set the where clause","user":{"login":"moxplod","id":4554395,"avatar_url":"https://avatars.githubusercontent.com/u/4554395?v=3","gravatar_id":"","url":"https://api.github.com/users/moxplod","html_url":"https://github.com/moxplod","followers_url":"https://api.github.com/users/moxplod/followers","following_url":"https://api.github.com/users/moxplod/following{/other_user}","gists_url":"https://api.github.com/users/moxplod/gists{/gist_id}","starred_url":"https://api.github.com/users/moxplod/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/moxplod/subscriptions","organizations_url":"https://api.github.com/users/moxplod/orgs","repos_url":"https://api.github.com/users/moxplod/repos","events_url":"https://api.github.com/users/moxplod/events{/privacy}","received_events_url":"https://api.github.com/users/moxplod/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/MoonStorm/Dapper.FastCRUD/labels/bug","name":"bug","color":"fc2929"},{"url":"https://api.github.com/repos/MoonStorm/Dapper.FastCRUD/labels/released%20(BETA)","name":"released (BETA)","color":"bfe5bf"}],"state":"closed","locked":false,"assignee":null,"milestone":{"url":"https://api.github.com/repos/MoonStorm/Dapper.FastCRUD/milestones/2","html_url":"https://github.com/MoonStorm/Dapper.FastCRUD/milestones/2.2.0","labels_url":"https://api.github.com/repos/MoonStorm/Dapper.FastCRUD/milestones/2/labels","id":1426416,"number":2,"title":"2.2.0","description":"- full support for table and column overrides \r\n- identifier delimiters used throughout \r\n- PostgreSql delimiters enforced \r\n- easy to override library conventions \r\n- enhanced SQL builder with a SQL formatter provider, with support for formatting specifiers for table (T), column (C) or table and column (TC) \r\n- support for the MetadataType attribute \r\n- fixed the INSERT statement in an MsSql table with triggers \r\n- fixed SKIP and TOP clauses for MsSql and SqLite \r\n- batch update & delete","creator":{"login":"MoonStorm","id":2178827,"avatar_url":"https://avatars.githubusercontent.com/u/2178827?v=3","gravatar_id":"","url":"https://api.github.com/users/MoonStorm","html_url":"https://github.com/MoonStorm","followers_url":"https://api.github.com/users/MoonStorm/followers","following_url":"https://api.github.com/users/MoonStorm/following{/other_user}","gists_url":"https://api.github.com/users/MoonStorm/gists{/gist_id}","starred_url":"https://api.github.com/users/MoonStorm/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/MoonStorm/subscriptions","organizations_url":"https://api.github.com/users/MoonStorm/orgs","repos_url":"https://api.github.com/users/MoonStorm/repos","events_url":"https://api.github.com/users/MoonStorm/events{/privacy}","received_events_url":"https://api.github.com/users/MoonStorm/received_events","type":"User","site_admin":false},"open_issues":0,"closed_issues":9,"state":"open","created_at":"2015-11-24T01:41:53Z","updated_at":"2015-12-08T03:51:40Z","due_on":"2015-11-29T07:00:00Z","closed_at":null},"comments":17,"created_at":"2015-11-23T22:48:54Z","updated_at":"2015-12-08T03:51:40Z","closed_at":"2015-12-08T03:51:40Z","body":"I want to do a batch delete. \r\n\r\nBut there is no way to set the where clause in IStandardSqlStatementOptionsSetter. \r\nThe ISqlStatementOptionsGetter has a way to read the where.\r\n\r\nAm i missing anything? I have not really gone into the sql generation logic much in this library yet."}}