Incomplete highlighting for keywords of SQLite SQL statement

[renkun-ken]

Suppose a SQL statement for SQLite is as follows:

SELECT *, price * volume AS totalValue 
FROM df 
WHERE price >= (SELECT AVG(price) FROM df)
ORDER BY totalValue DESC
LIMIT 100

highlight.js correctly highlights ordinary keywords in SQL standard except for LIMIT keyword for SQLite. Some other keywords in SQL-dialects are not supported either. Is there any possibility to support major SQL-dialects?

[isagalaev]

Sorry for taking so long to reply to this. By this time "LIMIT" is there and highlights properly. And we certainly can accept more keywords for SQL dialects. The best way to do this is to submit them as a pull requests.