When the pipe syntax was first published last year the SQLite team did a quick hack to try it out. https://sqlite.org/forum/forumpost/5f218012b6e1a9db https://

When the pipe syntax was first published last year the SQLite team did a quick hack to try it out. https://sqlite.org/forum/forumpost/5f218012b6e1a9db https://sqlite.org/forum/forumpost/5f218012b6e1a9db (Note that the fiddle linked no longer supports the syntax) It is very interesting that they found it completely unnecessary to actually require the pipe characters. The grammar works when the pipe characters are optional. And, imo, looks a lot better!