Syntax highlighting doesn't recognize line number output

[gvenzl]

Ideally line numbers 6, 7, 8, 9, 10 should not be highlighted as part of the quoted string:

[aalmiray]

Switched to PrismJS and it behaves in the same way that is, line number color is mixed.

[aalmiray]

Moving to PrismJS may be the first step to fix this as the highligh.js version bundled by Antora's default-ui is outdated and no longer compatible with latest releases. It's also easier to add new SQL keywords in this way.

[aalmiray]

Follow up at PrismJS https://github.com/orgs/PrismJS/discussions/3819