{"action":"created","issue":{"url":"https://api.github.com/repos/jdorn/sql-formatter/issues/82","labels_url":"https://api.github.com/repos/jdorn/sql-formatter/issues/82/labels{/name}","comments_url":"https://api.github.com/repos/jdorn/sql-formatter/issues/82/comments","events_url":"https://api.github.com/repos/jdorn/sql-formatter/issues/82/events","html_url":"https://github.com/jdorn/sql-formatter/pull/82","id":100859512,"number":82,"title":"Add SQL2003 window function syntax","user":{"login":"chanmix51","id":81580,"avatar_url":"https://avatars.githubusercontent.com/u/81580?v=3","gravatar_id":"","url":"https://api.github.com/users/chanmix51","html_url":"https://github.com/chanmix51","followers_url":"https://api.github.com/users/chanmix51/followers","following_url":"https://api.github.com/users/chanmix51/following{/other_user}","gists_url":"https://api.github.com/users/chanmix51/gists{/gist_id}","starred_url":"https://api.github.com/users/chanmix51/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/chanmix51/subscriptions","organizations_url":"https://api.github.com/users/chanmix51/orgs","repos_url":"https://api.github.com/users/chanmix51/repos","events_url":"https://api.github.com/users/chanmix51/events{/privacy}","received_events_url":"https://api.github.com/users/chanmix51/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":2,"created_at":"2015-08-13T20:18:52Z","updated_at":"2015-08-14T08:19:23Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/jdorn/sql-formatter/pulls/82","html_url":"https://github.com/jdorn/sql-formatter/pull/82","diff_url":"https://github.com/jdorn/sql-formatter/pull/82.diff","patch_url":"https://github.com/jdorn/sql-formatter/pull/82.patch"},"body":"Window functions keywords like `WINDOW`, `OVER`, `PARTITION` were not recognized and the SQL formatting was bad when these functions were used. "},"comment":{"url":"https://api.github.com/repos/jdorn/sql-formatter/issues/comments/131016300","html_url":"https://github.com/jdorn/sql-formatter/pull/82#issuecomment-131016300","issue_url":"https://api.github.com/repos/jdorn/sql-formatter/issues/82","id":131016300,"user":{"login":"chanmix51","id":81580,"avatar_url":"https://avatars.githubusercontent.com/u/81580?v=3","gravatar_id":"","url":"https://api.github.com/users/chanmix51","html_url":"https://github.com/chanmix51","followers_url":"https://api.github.com/users/chanmix51/followers","following_url":"https://api.github.com/users/chanmix51/following{/other_user}","gists_url":"https://api.github.com/users/chanmix51/gists{/gist_id}","starred_url":"https://api.github.com/users/chanmix51/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/chanmix51/subscriptions","organizations_url":"https://api.github.com/users/chanmix51/orgs","repos_url":"https://api.github.com/users/chanmix51/repos","events_url":"https://api.github.com/users/chanmix51/events{/privacy}","received_events_url":"https://api.github.com/users/chanmix51/received_events","type":"User","site_admin":false},"created_at":"2015-08-14T08:19:23Z","updated_at":"2015-08-14T08:19:23Z","body":"@stof true, I have made a diff of before and after:\r\n\r\n * added `WINDOW` after `INTERSECT`\r\n * added `OVER` after `OUTFILE`\r\n\r\nI have tested it in my own project's web debug toolbar and it works well.\r\n\r\n"}}