{"id":12097,"date":"2023-02-07T00:24:23","date_gmt":"2023-02-06T23:24:23","guid":{"rendered":"https:\/\/www.salvis.com\/blog\/?p=12097"},"modified":"2023-11-08T18:17:53","modified_gmt":"2023-11-08T17:17:53","slug":"islandsql-episode-2-all-dml-statements","status":"publish","type":"post","link":"https:\/\/www.salvis.com\/blog\/2023\/02\/07\/islandsql-episode-2-all-dml-statements\/","title":{"rendered":"IslandSQL Episode 2: All DML Statements"},"content":{"rendered":"\n

Introduction<\/h2>\n\n\n\n

In the last episode<\/a>, we build the initial version of IslandSQL. An Island grammar for SQL scripts covering select statements. In this blog post, we extend the grammar to handle the remaining DML statements.<\/p>\n\n\n\n

The full source code is available on GitHub<\/a> and the binaries on Maven Central<\/a>.<\/p>\n\n\n\n

Lexer Changes<\/h2>\n\n\n\n

The lexer grammar contains a new fragment COMMENT_OR_WS<\/code> on line 98. We use this fragment in all DML lexer rules after the starting keywords. Why? Because we can use comments beside whitespace after a keyword as in\u00a0with\/*comment*\/function e_count...<\/code>. The previous lexer version required a whitespace after the with<\/code> keyword for select<\/code> statements with a plsql_declarations<\/a> clause.<\/p>\n\n\n\n

I also merged the former PLSQL_DECLARATION<\/code> rule into the SELECT<\/code> rule. Mainly to have a single lexer rule for all DML statements. It’s more consistent and easier to understand IMO.<\/p>\n\n\n\n

IslandSqlLexer.g4: based on https:\/\/github.com\/IslandSQL\/IslandSQL\/tree\/v0.2.0\/<\/span><\/path><\/path><\/svg><\/span>
lexer<\/span> <\/span>grammar<\/span> <\/span>IslandSqlLexer<\/span>;<\/span><\/span>\n<\/span>\noptions<\/span> {<\/span><\/span>\n    <\/span>superClass<\/span>=<\/span>IslandSqlLexerBase<\/span>;<\/span><\/span>\n    <\/span>caseInsensitive<\/span> = <\/span>true<\/span>;<\/span><\/span>\n}<\/span><\/span>\n<\/span>\n\/*----------------------------------------------------------------------------*\/<\/span><\/span>\n\/\/ Comments and alike to be ignored<\/span><\/span>\n\/*----------------------------------------------------------------------------*\/<\/span><\/span>\n<\/span>\nML_COMMENT<\/span>: <\/span>'\/*'<\/span> .*? <\/span>'*\/'<\/span> -> <\/span>channel<\/span>(<\/span>HIDDEN<\/span>);<\/span><\/span>\nSL_COMMENT<\/span>: <\/span>'--'<\/span> .*? (<\/span>EOF<\/span>|<\/span>SINGLE_NL<\/span>) -> <\/span>channel<\/span>(<\/span>HIDDEN<\/span>);<\/span><\/span>\n<\/span>\nREMARK_COMMAND<\/span>:<\/span><\/span>\n    {<\/span>isBeginOfCommand<\/span>()}? <\/span>'rem'<\/span> (<\/span>'a'<\/span> (<\/span>'r'<\/span> <\/span>'k'<\/span>?)?)?<\/span><\/span>\n        (<\/span>WS<\/span> <\/span>SQLPLUS_TEXT<\/span>*)? <\/span>SQLPLUS_END<\/span> -> <\/span>channel<\/span>(<\/span>HIDDEN<\/span>)<\/span><\/span>\n;<\/span><\/span>\n<\/span>\nPROMPT_COMMAND<\/span>:<\/span><\/span>\n    {<\/span>isBeginOfCommand<\/span>()}? <\/span>'pro'<\/span> (<\/span>'m'<\/span> (<\/span>'p'<\/span> <\/span>'t'<\/span>?)?)?<\/span><\/span>\n       (<\/span>WS<\/span> <\/span>SQLPLUS_TEXT<\/span>*)? <\/span>SQLPLUS_END<\/span> -> <\/span>channel<\/span>(<\/span>HIDDEN<\/span>)<\/span><\/span>\n;<\/span><\/span>\n<\/span>\nSTRING<\/span>:<\/span><\/span>\n    <\/span>'n'<\/span>?<\/span><\/span>\n    (<\/span><\/span>\n          ([<\/span>'] .*? ['<\/span>])+<\/span><\/span>\n        | (<\/span>'q'<\/span> [<\/span>'] '<\/span>[<\/span>' .*? '<\/span>]<\/span>' ['<\/span>])<\/span><\/span>\n        | (<\/span>'q'<\/span> [<\/span>'] '<\/span>(<\/span>' .*? '<\/span>)<\/span>' ['<\/span>])<\/span><\/span>\n        | (<\/span>'q'<\/span> [<\/span>'] '<\/span>{<\/span>' .*? '<\/span>}<\/span>' ['<\/span>])<\/span><\/span>\n        | (<\/span>'q'<\/span> [<\/span>'] '<\/span><<\/span>' .*? '<\/span>><\/span>' ['<\/span>])<\/span><\/span>\n        | (<\/span>'q'<\/span> [<\/span>'] . {saveQuoteDelimiter1()}? .+? . ['<\/span>] {<\/span>checkQuoteDelimiter2<\/span>()}?)<\/span><\/span>\n    ) -> <\/span>channel<\/span>(<\/span>HIDDEN<\/span>)<\/span><\/span>\n;<\/span><\/span>\n<\/span>\nCONDITIONAL_COMPILATION_DIRECTIVE<\/span>: <\/span>'$if'<\/span> .*? <\/span>'$end'<\/span> -> <\/span>channel<\/span>(<\/span>HIDDEN<\/span>);<\/span><\/span>\n<\/span>\n\/*----------------------------------------------------------------------------*\/<\/span><\/span>\n\/\/ Islands of interest on DEFAULT_CHANNEL<\/span><\/span>\n\/*----------------------------------------------------------------------------*\/<\/span><\/span>\n<\/span>\nCALL<\/span>:<\/span><\/span>\n    {<\/span>isBeginOfStatement<\/span>()}? <\/span>'call'<\/span> <\/span>COMMENT_OR_WS<\/span>+ <\/span>SQL_TEXT<\/span>+? <\/span>SQL_END<\/span><\/span>\n;<\/span><\/span>\n<\/span>\nDELETE<\/span>:<\/span><\/span>\n    {<\/span>isBeginOfStatement<\/span>()}? <\/span>'delete'<\/span> <\/span>COMMENT_OR_WS<\/span>+ <\/span>SQL_TEXT<\/span>+? <\/span>SQL_END<\/span><\/span>\n;<\/span><\/span>\n<\/span>\nEXPLAIN_PLAN<\/span>:<\/span><\/span>\n    {<\/span>isBeginOfStatement<\/span>()}? <\/span>'explain'<\/span> <\/span>COMMENT_OR_WS<\/span>+ <\/span>'plan'<\/span> <\/span>COMMENT_OR_WS<\/span>+ <\/span>SQL_TEXT<\/span>+? <\/span>SQL_END<\/span><\/span>\n;<\/span><\/span>\n<\/span>\nINSERT<\/span>:<\/span><\/span>\n    {<\/span>isBeginOfStatement<\/span>()}? <\/span>'insert'<\/span> <\/span>COMMENT_OR_WS<\/span>+ <\/span>SQL_TEXT<\/span>+? <\/span>SQL_END<\/span><\/span>\n;<\/span><\/span>\n<\/span>\nLOCK_TABLE<\/span>:<\/span><\/span>\n    {<\/span>isBeginOfStatement<\/span>()}? <\/span>'lock'<\/span> <\/span>COMMENT_OR_WS<\/span>+ <\/span>'table'<\/span> <\/span>COMMENT_OR_WS<\/span>+ <\/span>SQL_TEXT<\/span>+? <\/span>SQL_END<\/span><\/span>\n;<\/span><\/span>\n<\/span>\nMERGE<\/span>:<\/span><\/span>\n    {<\/span>isBeginOfStatement<\/span>()}? <\/span>'merge'<\/span> <\/span>COMMENT_OR_WS<\/span>+ <\/span>SQL_TEXT<\/span>+? <\/span>SQL_END<\/span><\/span>\n;<\/span><\/span>\n<\/span>\nUPDATE<\/span>:<\/span><\/span>\n    {<\/span>isBeginOfStatement<\/span>()}? <\/span>'update'<\/span> <\/span>COMMENT_OR_WS<\/span>+ <\/span>SQL_TEXT<\/span>+? <\/span>SQL_END<\/span><\/span>\n;<\/span><\/span>\n<\/span>\nSELECT<\/span>:<\/span><\/span>\n    {<\/span>isBeginOfStatement<\/span>()}?<\/span><\/span>\n    (<\/span><\/span>\n          (<\/span>'with'<\/span> <\/span>COMMENT_OR_WS<\/span>+ (<\/span>'function'<\/span>|<\/span>'procedure'<\/span>) <\/span>SQL_TEXT<\/span>+? <\/span>PLSQL_DECLARATION_END<\/span>)<\/span><\/span>\n        | (<\/span>'with'<\/span> <\/span>COMMENT_OR_WS<\/span>+ <\/span>SQL_TEXT<\/span>+? <\/span>SQL_END<\/span>)<\/span><\/span>\n        | ((<\/span>'('<\/span> <\/span>COMMENT_OR_WS<\/span>*)* <\/span>'select'<\/span> <\/span>COMMENT_OR_WS<\/span> <\/span>SQL_TEXT<\/span>+? <\/span>SQL_END<\/span>)<\/span><\/span>\n    )<\/span><\/span>\n;<\/span><\/span>\n<\/span>\n\/*----------------------------------------------------------------------------*\/<\/span><\/span>\n\/\/ Whitespace<\/span><\/span>\n\/*----------------------------------------------------------------------------*\/<\/span><\/span>\n<\/span>\nWS<\/span>: [ \\<\/span>t<\/span>\\<\/span>r<\/span>\\<\/span>n<\/span>]+ -> <\/span>channel<\/span>(<\/span>HIDDEN<\/span>);<\/span><\/span>\n<\/span>\n\/*----------------------------------------------------------------------------*\/<\/span><\/span>\n\/\/ Any other token<\/span><\/span>\n\/*----------------------------------------------------------------------------*\/<\/span><\/span>\n<\/span>\nANY_OTHER<\/span>: . -> <\/span>channel<\/span>(<\/span>HIDDEN<\/span>);<\/span><\/span>\n<\/span>\n\/*----------------------------------------------------------------------------*\/<\/span><\/span>\n\/\/ Fragments to name expressions and reduce code duplication<\/span><\/span>\n\/*----------------------------------------------------------------------------*\/<\/span><\/span>\n<\/span>\nfragment<\/span> <\/span>SINGLE_NL<\/span>: <\/span>'<\/span>\\r<\/span>'<\/span>? <\/span>'<\/span>\\n<\/span>'<\/span>;<\/span><\/span>\nfragment<\/span> <\/span>CONTINUE_LINE<\/span>: <\/span>'-'<\/span> [ \\<\/span>t<\/span>]* <\/span>SINGLE_NL<\/span>;<\/span><\/span>\nfragment<\/span> <\/span>COMMENT_OR_WS<\/span>: <\/span>ML_COMMENT<\/span>|<\/span>SL_COMMENT<\/span>|<\/span>WS<\/span>;<\/span><\/span>\nfragment<\/span> <\/span>SQLPLUS_TEXT<\/span>: (~[\\<\/span>r<\/span>\\<\/span>n<\/span>]|<\/span>CONTINUE_LINE<\/span>);<\/span><\/span>\nfragment<\/span> <\/span>SQL_TEXT<\/span>: (<\/span>ML_COMMENT<\/span>|<\/span>SL_COMMENT<\/span>|<\/span>STRING<\/span>|.);<\/span><\/span>\nfragment<\/span> <\/span>SLASH_END<\/span>: <\/span>SINGLE_NL<\/span> <\/span>WS<\/span>* <\/span>'\/'<\/span> [ \\<\/span>t<\/span>]* (<\/span>EOF<\/span>|<\/span>SINGLE_NL<\/span>);<\/span><\/span>\nfragment<\/span> <\/span>PLSQL_DECLARATION_END<\/span>: <\/span>';'<\/span>? [ \\<\/span>t<\/span>]* (<\/span>EOF<\/span>|<\/span>SLASH_END<\/span>);<\/span><\/span>\nfragment<\/span> <\/span>SQL_END<\/span>:<\/span><\/span>\n      <\/span>EOF<\/span><\/span>\n    | (<\/span>';'<\/span> [ \\<\/span>t<\/span>]* <\/span>SINGLE_NL<\/span>?)<\/span><\/span>\n    | <\/span>SLASH_END<\/span><\/span>\n;<\/span><\/span>\nfragment<\/span> <\/span>SQLPLUS_END<\/span>: <\/span>EOF<\/span>|<\/span>SINGLE_NL<\/span>;<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
Parser Changes<\/h2>\n\n\n\n
The start rule file<\/code> on line 11 in the parser grammar is now defined as a unbounded number of dmlStatment<\/code>. Each DML statement<\/a> is a single lexer token. It’s still not possible to produce a parse error with this grammar. We only process DML statements. Everything else is hidden and therefore ignored.<\/p>\n\n\n\n
IslandSqlParser.g4: based on https:\/\/github.com\/IslandSQL\/IslandSQL\/tree\/v0.2.0\/<\/span><\/path><\/path><\/svg><\/span>
parser<\/span> <\/span>grammar<\/span> <\/span>IslandSqlParser<\/span>;<\/span><\/span>\n<\/span>\noptions<\/span> {<\/span><\/span>\n    <\/span>tokenVocab<\/span>=<\/span>IslandSqlLexer<\/span>;<\/span><\/span>\n}<\/span><\/span>\n<\/span>\n\/*----------------------------------------------------------------------------*\/<\/span><\/span>\n\/\/ Start rule<\/span><\/span>\n\/*----------------------------------------------------------------------------*\/<\/span><\/span>\n<\/span>\nfile<\/span>: <\/span>dmlStatement<\/span>* <\/span>EOF<\/span>;<\/span><\/span>\n<\/span>\n\/*----------------------------------------------------------------------------*\/<\/span><\/span>\n\/\/ Rules for reduced SQL grammar (islands of interest)<\/span><\/span>\n\/*----------------------------------------------------------------------------*\/<\/span><\/span>\n<\/span>\ndmlStatement<\/span>:<\/span><\/span>\n      <\/span>callStatement<\/span><\/span>\n    | <\/span>deleteStatement<\/span><\/span>\n    | <\/span>explainPlanStatement<\/span><\/span>\n    | <\/span>insertStatement<\/span><\/span>\n    | <\/span>lockTableStatement<\/span><\/span>\n    | <\/span>mergeStatement<\/span><\/span>\n    | <\/span>selectStatement<\/span><\/span>\n    | <\/span>updateStatement<\/span><\/span>\n;<\/span><\/span>\n<\/span>\ncallStatement<\/span>: <\/span>CALL<\/span>;<\/span><\/span>\ndeleteStatement<\/span>: <\/span>DELETE<\/span>;<\/span><\/span>\nexplainPlanStatement<\/span>: <\/span>EXPLAIN_PLAN<\/span>;<\/span><\/span>\ninsertStatement<\/span>: <\/span>INSERT<\/span>;<\/span><\/span>\nlockTableStatement<\/span>: <\/span>LOCK_TABLE<\/span>;<\/span><\/span>\nmergeStatement<\/span>: <\/span>MERGE<\/span>;<\/span><\/span>\nupdateStatement<\/span>: <\/span>UPDATE<\/span>;<\/span><\/span>\nselectStatement<\/span>: <\/span>SELECT<\/span>;<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
IslandSQL for VS Code<\/h2>\n\n\n\n
The extension<\/a> for Visual Studio Code version 0.2.0 finds text in all DML statements and is not limited to select<\/code> statements anymore. And a symbol for each DML statement is shown now in the outline view.<\/p>\n\n\n\n
\"\"<\/a><\/figure>\n\n\n\n
Outlook<\/h2>\n\n\n\n
A grammar that can parse all DML statements sounds like something complete. However, this grammar is far from complete. For code analysis, getting a single token for a DML statement is at best a good starting point.<\/p>\n\n\n\n
What we need is a more detailed result. For this, we need to move the logic from the lexer to the parser. In the next episode, we will do this with one of the DML statements.<\/p>\n","protected":false},"excerpt":{"rendered":"
Introduction In the last episode, we build the initial version of IslandSQL. An Island grammar for SQL scripts covering select statements. In this blog post, we extend the grammar to handle the remaining DML statements. The full source code is available on GitHub and the binaries on Maven Central. Lexer Changes The [\u2026]<\/span><\/p>\n","protected":false},"author":1,"featured_media":12096,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[139,86,137,107,85,138],"class_list":["post-12097","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-oracle","tag-antlr","tag-code-analysis","tag-islandsql","tag-java","tag-sql","tag-vscode"],"yoast_head":"\nIslandSQL Episode 2: All DML Statements - Philipp Salvisberg's Blog<\/title>\n<meta name=\"description\" content=\"In this blog post, we extend IslandSQL, an island grammar for SQL scripts, to cover all SQL data manipulation statements.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.salvis.com\/blog\/2023\/02\/07\/islandsql-episode-2-all-dml-statements\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"IslandSQL Episode 2: All DML Statements - Philipp Salvisberg's Blog\" \/>\n<meta property=\"og:description\" content=\"In this blog post, we extend IslandSQL, an island grammar for SQL scripts, to cover all SQL data manipulation statements.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.salvis.com\/blog\/2023\/02\/07\/islandsql-episode-2-all-dml-statements\/\" \/>\n<meta property=\"og:site_name\" content=\"Philipp Salvisberg's Blog\" \/>\n<meta property=\"article:published_time\" content=\"2023-02-06T23:24:23+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-11-08T17:17:53+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.salvis.com\/blog\/wp-content\/uploads\/2023\/02\/IslandSQL2.png\" \/>\n\t<meta property=\"og:image:width\" content=\"500\" \/>\n\t<meta property=\"og:image:height\" content=\"500\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Philipp Salvisberg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@phsalvisberg\" \/>\n<meta name=\"twitter:site\" content=\"@phsalvisberg\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Philipp Salvisberg\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/2023\\\/02\\\/07\\\/islandsql-episode-2-all-dml-statements\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/2023\\\/02\\\/07\\\/islandsql-episode-2-all-dml-statements\\\/\"},\"author\":{\"name\":\"Philipp Salvisberg\",\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/#\\\/schema\\\/person\\\/34352245c48678b1a5a05d4bc1339515\"},\"headline\":\"IslandSQL Episode 2: All DML Statements\",\"datePublished\":\"2023-02-06T23:24:23+00:00\",\"dateModified\":\"2023-11-08T17:17:53+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/2023\\\/02\\\/07\\\/islandsql-episode-2-all-dml-statements\\\/\"},\"wordCount\":323,\"commentCount\":1,\"publisher\":{\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/#\\\/schema\\\/person\\\/34352245c48678b1a5a05d4bc1339515\"},\"image\":{\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/2023\\\/02\\\/07\\\/islandsql-episode-2-all-dml-statements\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/02\\\/IslandSQL2.png\",\"keywords\":[\"ANTLR\",\"Code Analysis\",\"IslandSQL\",\"Java\",\"SQL\",\"VSCode\"],\"articleSection\":[\"Oracle\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.salvis.com\\\/blog\\\/2023\\\/02\\\/07\\\/islandsql-episode-2-all-dml-statements\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/2023\\\/02\\\/07\\\/islandsql-episode-2-all-dml-statements\\\/\",\"url\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/2023\\\/02\\\/07\\\/islandsql-episode-2-all-dml-statements\\\/\",\"name\":\"IslandSQL Episode 2: All DML Statements - Philipp Salvisberg's Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/2023\\\/02\\\/07\\\/islandsql-episode-2-all-dml-statements\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/2023\\\/02\\\/07\\\/islandsql-episode-2-all-dml-statements\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/02\\\/IslandSQL2.png\",\"datePublished\":\"2023-02-06T23:24:23+00:00\",\"dateModified\":\"2023-11-08T17:17:53+00:00\",\"description\":\"In this blog post, we extend IslandSQL, an island grammar for SQL scripts, to cover all SQL data manipulation statements.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/2023\\\/02\\\/07\\\/islandsql-episode-2-all-dml-statements\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.salvis.com\\\/blog\\\/2023\\\/02\\\/07\\\/islandsql-episode-2-all-dml-statements\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/2023\\\/02\\\/07\\\/islandsql-episode-2-all-dml-statements\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/02\\\/IslandSQL2.png\",\"contentUrl\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/02\\\/IslandSQL2.png\",\"width\":500,\"height\":500},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/2023\\\/02\\\/07\\\/islandsql-episode-2-all-dml-statements\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"IslandSQL Episode 2: All DML Statements\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/\",\"name\":\"Philipp Salvisberg's Blog\",\"description\":\"Database-centric development\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/#\\\/schema\\\/person\\\/34352245c48678b1a5a05d4bc1339515\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/#\\\/schema\\\/person\\\/34352245c48678b1a5a05d4bc1339515\",\"name\":\"Philipp Salvisberg\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/wp-content\\\/uploads\\\/2010\\\/11\\\/phs_trivadis4.jpg\",\"url\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/wp-content\\\/uploads\\\/2010\\\/11\\\/phs_trivadis4.jpg\",\"contentUrl\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/wp-content\\\/uploads\\\/2010\\\/11\\\/phs_trivadis4.jpg\",\"width\":400,\"height\":400,\"caption\":\"Philipp Salvisberg\"},\"logo\":{\"@id\":\"https:\\\/\\\/www.salvis.com\\\/blog\\\/wp-content\\\/uploads\\\/2010\\\/11\\\/phs_trivadis4.jpg\"},\"sameAs\":[\"http:\\\/\\\/www.salvis.com\\\/\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"IslandSQL Episode 2: All DML Statements - Philipp Salvisberg's Blog","description":"In this blog post, we extend IslandSQL, an island grammar for SQL scripts, to cover all SQL data manipulation statements.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.salvis.com\/blog\/2023\/02\/07\/islandsql-episode-2-all-dml-statements\/","og_locale":"en_US","og_type":"article","og_title":"IslandSQL Episode 2: All DML Statements - Philipp Salvisberg's Blog","og_description":"In this blog post, we extend IslandSQL, an island grammar for SQL scripts, to cover all SQL data manipulation statements.","og_url":"https:\/\/www.salvis.com\/blog\/2023\/02\/07\/islandsql-episode-2-all-dml-statements\/","og_site_name":"Philipp Salvisberg's Blog","article_published_time":"2023-02-06T23:24:23+00:00","article_modified_time":"2023-11-08T17:17:53+00:00","og_image":[{"width":500,"height":500,"url":"https:\/\/www.salvis.com\/blog\/wp-content\/uploads\/2023\/02\/IslandSQL2.png","type":"image\/png"}],"author":"Philipp Salvisberg","twitter_card":"summary_large_image","twitter_creator":"@phsalvisberg","twitter_site":"@phsalvisberg","twitter_misc":{"Written by":"Philipp Salvisberg","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.salvis.com\/blog\/2023\/02\/07\/islandsql-episode-2-all-dml-statements\/#article","isPartOf":{"@id":"https:\/\/www.salvis.com\/blog\/2023\/02\/07\/islandsql-episode-2-all-dml-statements\/"},"author":{"name":"Philipp Salvisberg","@id":"https:\/\/www.salvis.com\/blog\/#\/schema\/person\/34352245c48678b1a5a05d4bc1339515"},"headline":"IslandSQL Episode 2: All DML Statements","datePublished":"2023-02-06T23:24:23+00:00","dateModified":"2023-11-08T17:17:53+00:00","mainEntityOfPage":{"@id":"https:\/\/www.salvis.com\/blog\/2023\/02\/07\/islandsql-episode-2-all-dml-statements\/"},"wordCount":323,"commentCount":1,"publisher":{"@id":"https:\/\/www.salvis.com\/blog\/#\/schema\/person\/34352245c48678b1a5a05d4bc1339515"},"image":{"@id":"https:\/\/www.salvis.com\/blog\/2023\/02\/07\/islandsql-episode-2-all-dml-statements\/#primaryimage"},"thumbnailUrl":"https:\/\/www.salvis.com\/blog\/wp-content\/uploads\/2023\/02\/IslandSQL2.png","keywords":["ANTLR","Code Analysis","IslandSQL","Java","SQL","VSCode"],"articleSection":["Oracle"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.salvis.com\/blog\/2023\/02\/07\/islandsql-episode-2-all-dml-statements\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.salvis.com\/blog\/2023\/02\/07\/islandsql-episode-2-all-dml-statements\/","url":"https:\/\/www.salvis.com\/blog\/2023\/02\/07\/islandsql-episode-2-all-dml-statements\/","name":"IslandSQL Episode 2: All DML Statements - Philipp Salvisberg's Blog","isPartOf":{"@id":"https:\/\/www.salvis.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.salvis.com\/blog\/2023\/02\/07\/islandsql-episode-2-all-dml-statements\/#primaryimage"},"image":{"@id":"https:\/\/www.salvis.com\/blog\/2023\/02\/07\/islandsql-episode-2-all-dml-statements\/#primaryimage"},"thumbnailUrl":"https:\/\/www.salvis.com\/blog\/wp-content\/uploads\/2023\/02\/IslandSQL2.png","datePublished":"2023-02-06T23:24:23+00:00","dateModified":"2023-11-08T17:17:53+00:00","description":"In this blog post, we extend IslandSQL, an island grammar for SQL scripts, to cover all SQL data manipulation statements.","breadcrumb":{"@id":"https:\/\/www.salvis.com\/blog\/2023\/02\/07\/islandsql-episode-2-all-dml-statements\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.salvis.com\/blog\/2023\/02\/07\/islandsql-episode-2-all-dml-statements\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.salvis.com\/blog\/2023\/02\/07\/islandsql-episode-2-all-dml-statements\/#primaryimage","url":"https:\/\/www.salvis.com\/blog\/wp-content\/uploads\/2023\/02\/IslandSQL2.png","contentUrl":"https:\/\/www.salvis.com\/blog\/wp-content\/uploads\/2023\/02\/IslandSQL2.png","width":500,"height":500},{"@type":"BreadcrumbList","@id":"https:\/\/www.salvis.com\/blog\/2023\/02\/07\/islandsql-episode-2-all-dml-statements\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.salvis.com\/blog\/"},{"@type":"ListItem","position":2,"name":"IslandSQL Episode 2: All DML Statements"}]},{"@type":"WebSite","@id":"https:\/\/www.salvis.com\/blog\/#website","url":"https:\/\/www.salvis.com\/blog\/","name":"Philipp Salvisberg's Blog","description":"Database-centric development","publisher":{"@id":"https:\/\/www.salvis.com\/blog\/#\/schema\/person\/34352245c48678b1a5a05d4bc1339515"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.salvis.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/www.salvis.com\/blog\/#\/schema\/person\/34352245c48678b1a5a05d4bc1339515","name":"Philipp Salvisberg","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.salvis.com\/blog\/wp-content\/uploads\/2010\/11\/phs_trivadis4.jpg","url":"https:\/\/www.salvis.com\/blog\/wp-content\/uploads\/2010\/11\/phs_trivadis4.jpg","contentUrl":"https:\/\/www.salvis.com\/blog\/wp-content\/uploads\/2010\/11\/phs_trivadis4.jpg","width":400,"height":400,"caption":"Philipp Salvisberg"},"logo":{"@id":"https:\/\/www.salvis.com\/blog\/wp-content\/uploads\/2010\/11\/phs_trivadis4.jpg"},"sameAs":["http:\/\/www.salvis.com\/"]}]}},"_links":{"self":[{"href":"https:\/\/www.salvis.com\/blog\/wp-json\/wp\/v2\/posts\/12097","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.salvis.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.salvis.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.salvis.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.salvis.com\/blog\/wp-json\/wp\/v2\/comments?post=12097"}],"version-history":[{"count":23,"href":"https:\/\/www.salvis.com\/blog\/wp-json\/wp\/v2\/posts\/12097\/revisions"}],"predecessor-version":[{"id":12732,"href":"https:\/\/www.salvis.com\/blog\/wp-json\/wp\/v2\/posts\/12097\/revisions\/12732"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.salvis.com\/blog\/wp-json\/wp\/v2\/media\/12096"}],"wp:attachment":[{"href":"https:\/\/www.salvis.com\/blog\/wp-json\/wp\/v2\/media?parent=12097"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.salvis.com\/blog\/wp-json\/wp\/v2\/categories?post=12097"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.salvis.com\/blog\/wp-json\/wp\/v2\/tags?post=12097"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}