René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Support \"Returning\" part of DELETE statement.","articleBody":"Hello!\r\n\r\nOur user expecting some problem with DELETE statement with returning clause. \r\nhttps://github.com/dbeaver/dbeaver/issues/15946\r\n\r\nBecause `delete from t returning *;` statement can't be parsed\r\nPlease, add support of RETURNING clause in DELETE statement.\r\n\r\n```\r\nEncountered unexpected token: \"returning\" \"RETURNING\"\r\n    at line 1, column 15.\r\n\r\nWas expecting one of:\r\n\r\n    \";\"\r\n    \"ACTION\"\r\n    \"ACTIVE\"\r\n    \"ALGORITHM\"\r\n    \"ARCHIVE\"\r\n    \"ARRAY\"\r\n    \"AS\"\r\n    \"AT\"\r\n    \"BYTE\"\r\n    \"CASCADE\"\r\n    \"CASE\"\r\n    \"CAST\"\r\n    \"CHANGE\"\r\n    \"CHAR\"\r\n    \"CHARACTER\"\r\n    \"CHECKPOINT\"\r\n    \"COLUMN\"\r\n    \"COLUMNS\"\r\n    \"COMMENT\"\r\n    \"COMMIT\"\r\n    \"COSTS\"\r\n    \"CYCLE\"\r\n    \"DBA_RECYCLEBIN\"\r\n    \"DESC\"\r\n    \"DESCRIBE\"\r\n    \"DISABLE\"\r\n    \"DISCONNECT\"\r\n    \"DIV\"\r\n    \"DO\"\r\n    \"DUMP\"\r\n    \"DUPLICATE\"\r\n    \"ENABLE\"\r\n    \"END\"\r\n    \"EXCLUDE\"\r\n    \"EXTRACT\"\r\n    \"FALSE\"\r\n    \"FILTER\"\r\n    \"FIRST\"\r\n    \"FLUSH\"\r\n    \"FN\"\r\n    \"FOLLOWING\"\r\n    \"FORMAT\"\r\n    \"FULLTEXT\"\r\n    \"HISTORY\"\r\n    \"INDEX\"\r\n    \"INSERT\"\r\n    \"INTERVAL\"\r\n    \"ISNULL\"\r\n    \"JSON\"\r\n    \"KEY\"\r\n    \"LAST\"\r\n    \"LEADING\"\r\n    \"LIMIT\"\r\n    \"LINK\"\r\n    \"LOCAL\"\r\n    \"LOG\"\r\n    \"MATERIALIZED\"\r\n    \"NO\"\r\n    \"NOLOCK\"\r\n    \"NULLS\"\r\n    \"OF\"\r\n    \"OPEN\"\r\n    \"ORDER\"\r\n    \"OVER\"\r\n    \"PARALLEL\"\r\n    \"PARTITION\"\r\n    \"PATH\"\r\n    \"PERCENT\"\r\n    \"PRECISION\"\r\n    \"PRIMARY\"\r\n    \"PRIOR\"\r\n    \"QUERY\"\r\n    \"QUIESCE\"\r\n    \"RANGE\"\r\n    \"READ\"\r\n    \"RECYCLEBIN\"\r\n    \"REGISTER\"\r\n    \"REPLACE\"\r\n    \"RESTRICTED\"\r\n    \"RESUME\"\r\n    \"ROW\"\r\n    \"ROWS\"\r\n    \"SCHEMA\"\r\n    \"SEPARATOR\"\r\n    \"SEQUENCE\"\r\n    \"SESSION\"\r\n    \"SHUTDOWN\"\r\n    \"SIBLINGS\"\r\n    \"SIGNED\"\r\n    \"SIZE\"\r\n    \"SKIP\"\r\n    \"SUSPEND\"\r\n    \"SWITCH\"\r\n    \"SYNONYM\"\r\n    \"SYSTEM\"\r\n    \"TABLE\"\r\n    \"TABLESPACE\"\r\n    \"TEMP\"\r\n    \"TEMPORARY\"\r\n    \"TIMEOUT\"\r\n    \"TO\"\r\n    \"TOP\"\r\n    \"TRUE\"\r\n    \"TRUNCATE\"\r\n    \"TRY_CAST\"\r\n    \"TYPE\"\r\n    \"UNQIESCE\"\r\n    \"UNSIGNED\"\r\n    \"USER\"\r\n    \"USING\"\r\n    \"VALIDATE\"\r\n    \"VALUE\"\r\n    \"VALUES\"\r\n    \"VIEW\"\r\n    \"WHERE\"\r\n    \"XML\"\r\n    \"ZONE\"\r\n    \u003cEOF\u003e\r\n    \u003cK_DATETIMELITERAL\u003e\r\n    \u003cK_DATE_LITERAL\u003e\r\n    \u003cK_NEXTVAL\u003e\r\n    \u003cK_STRING_FUNCTION_NAME\u003e\r\n    \u003cS_CHAR_LITERAL\u003e\r\n    \u003cS_IDENTIFIER\u003e\r\n    \u003cS_QUOTED_IDENTIFIER\u003e\r\n```\r\n\r\n**SQL Example**\r\nThis statement doesn't work.\r\n\r\n`delete from t returning *;`\r\n\r\nAnd Update statement already support returning statement:\r\n\r\n`update t set a = 1 returning *;`\r\n\r\nI see that [UPDATE](https://github.com/JSQLParser/JSqlParser/blob/master/src/main/java/net/sf/jsqlparser/statement/update/Update.java) supports returning clause, and [DELETE](https://github.com/JSQLParser/JSqlParser/blob/master/src/main/java/net/sf/jsqlparser/statement/delete/Delete.java) statement - don't.\r\n\r\n**Software Information**\r\n- JSqlParser version - 4.2\r\n- Database - PostgreSQL\r\n","author":{"url":"https://github.com/LonwoLonwo","@type":"Person","name":"LonwoLonwo"},"datePublished":"2022-05-06T09:12:04.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":1},"url":"https://github.com/1527/JSqlParser/issues/1527"}