Feature/support update return - Githubissues

future-architect / uroboroSQL-formatter

Beautiful SQL Formatter

BSD 3-Clause "New" or "Revised" License

39 stars 12 forks source link

Feature/support update return #10

Closed ma91n closed 2 years ago

ma91n commented 2 years ago

Diff

[x] update cli tool version
- hitect/uroboroSQL-formatter/issues/7
[x] support RETURNING postgresql
- https://www.postgresql.jp/document/9.6/html/dml-returning.html
- Since postgresql 8.2
- https://github.com/future-architect/uroboroSQL-formatter/issues/9

Change

Before

INSERT INTO users (id, user_name, user_addr) VALUES('001', 'hoge', 'tokyo') RETURNING user_id;

After

INSERT
INTO
    USERS
(
    ID
,   USER_NAME
,   USER_ADDR
) VALUES (
    '001'
,   'hoge'
,   'tokyo'
)   RETURNING
USER_ID
;