{"action":"opened","issue":{"url":"https://api.github.com/repos/jOOQ/jOOQ/issues/7284","repository_url":"https://api.github.com/repos/jOOQ/jOOQ","labels_url":"https://api.github.com/repos/jOOQ/jOOQ/issues/7284/labels{/name}","comments_url":"https://api.github.com/repos/jOOQ/jOOQ/issues/7284/comments","events_url":"https://api.github.com/repos/jOOQ/jOOQ/issues/7284/events","html_url":"https://github.com/jOOQ/jOOQ/issues/7284","id":304331954,"number":7284,"title":"Add parser option to recognise and replace patterns","user":{"login":"lukaseder","id":734593,"avatar_url":"https://avatars2.githubusercontent.com/u/734593?v=4","gravatar_id":"","url":"https://api.github.com/users/lukaseder","html_url":"https://github.com/lukaseder","followers_url":"https://api.github.com/users/lukaseder/followers","following_url":"https://api.github.com/users/lukaseder/following{/other_user}","gists_url":"https://api.github.com/users/lukaseder/gists{/gist_id}","starred_url":"https://api.github.com/users/lukaseder/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/lukaseder/subscriptions","organizations_url":"https://api.github.com/users/lukaseder/orgs","repos_url":"https://api.github.com/users/lukaseder/repos","events_url":"https://api.github.com/users/lukaseder/events{/privacy}","received_events_url":"https://api.github.com/users/lukaseder/received_events","type":"User","site_admin":false},"labels":[{"id":9935131,"url":"https://api.github.com/repos/jOOQ/jOOQ/labels/C:%20Functionality","name":"C: Functionality","color":"0000aa","default":false},{"id":9935166,"url":"https://api.github.com/repos/jOOQ/jOOQ/labels/P:%20Medium","name":"P: Medium","color":"ffaaaa","default":false},{"id":9935128,"url":"https://api.github.com/repos/jOOQ/jOOQ/labels/T:%20Enhancement","name":"T: Enhancement","color":"cccccc","default":false}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":{"url":"https://api.github.com/repos/jOOQ/jOOQ/milestones/140","html_url":"https://github.com/jOOQ/jOOQ/milestone/140","labels_url":"https://api.github.com/repos/jOOQ/jOOQ/milestones/140/labels","id":2289955,"number":140,"title":"Version 3.11.0","description":"","creator":{"login":"lukaseder","id":734593,"avatar_url":"https://avatars2.githubusercontent.com/u/734593?v=4","gravatar_id":"","url":"https://api.github.com/users/lukaseder","html_url":"https://github.com/lukaseder","followers_url":"https://api.github.com/users/lukaseder/followers","following_url":"https://api.github.com/users/lukaseder/following{/other_user}","gists_url":"https://api.github.com/users/lukaseder/gists{/gist_id}","starred_url":"https://api.github.com/users/lukaseder/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/lukaseder/subscriptions","organizations_url":"https://api.github.com/users/lukaseder/orgs","repos_url":"https://api.github.com/users/lukaseder/repos","events_url":"https://api.github.com/users/lukaseder/events{/privacy}","received_events_url":"https://api.github.com/users/lukaseder/received_events","type":"User","site_admin":false},"open_issues":537,"closed_issues":392,"state":"open","created_at":"2017-01-31T16:47:44Z","updated_at":"2018-03-12T11:21:01Z","due_on":null,"closed_at":null},"comments":0,"created_at":"2018-03-12T11:21:00Z","updated_at":"2018-03-12T11:21:00Z","closed_at":null,"author_association":"OWNER","body":"There are some common expressions that can be simplified by the jOOQ parser into better equivalents, such as:\r\n\r\n```sql\r\n-- Input\r\nRTRIM(LTRIM(something))\r\n\r\n-- Output\r\nTRIM(something)\r\n```\r\n\r\nIn the above example, if jOOQ has a `trim()` function in its expression tree, that will perform (and look) better in all dialects that support it, while it still can be transformed back to `RTRIM(LTRIM(...))` on the other dialects.\r\n\r\nThis should be an opt-out feature. The following list of transformations will be implemented (list will be enhanced):\r\n\r\n- [ ] `RTRIM(LTRIM(x))` => `TRIM(x)`\r\n- [ ] `LTRIM(RTRIM(x))` => `TRIM(x)`\r\n"}}
{"actor":{"display_login":"lukaseder"}}