SQL:2023 support

[markandrus]

There are some features in SQL:2023 that would be useful to cover. What is the process for adding to this project? Also, the README.md mentions

This project contains grammars for the ANSI SQL Standards (taken from
the drafts).

Where can the drafts be accessed?

[JakeWheat]

The bad news is: you usually get the SQL drafts by trying to find someone who's sharing them using a search engine. I think it's pretty unofficial. I'm not sure if there's an official way to get the drafts.

To update the project to add SQL:2023, what's needed is to find the draft document, which is a PDF, convert it to txt using pdftotext from poppler, with the layout option, and possibly some others. Then in the past I used emacs with incremental search to manually extract the grammar - it's tedious but doesn't take that long, tens of minutes IIRC. It may also need a handful of manual tweaks to fix up some particular weird bits. Then it should be easy to use the existing toolchain to generate the hyperlinked version.

Please see if you can find a draft, and give it a go, if you get stuck, let me know and I can help. If we get it done, we can make sure this process is better documented.

[markandrus]

Thank you, I will keep my eyes peeled!