Column types are highlighted correctly in CREATE TABLE statements.

create table students(
  name text,
  age int,
  progress decimal(20),
  data json
);

CREATE VIRTUAL TABLE statements, which are unique to SQLite, is also highlighted correctly.


create virtual table fts_emails using fts5(name, email, body);

All builtin functions to most SQLite builds and most shell builtin functions are highlighted as well.


select

  -- all SQLite builtins functions are supported
  sqlite_version(),
  datetime() as created_at,
  format('%s %s', first_name, last_name) as name,
  max(age) as oldest,

  -- As well as JSON functions, including the new ->/->> syntax!
  json_extract(data, '$.email') as email,
  data ->> 'mailing_address'  as mailing_address
from students
-- and builtin table functions!
join json_each(students.assignments, '$.data')

If you include the sqlite> prompt prefix from the SQLite CLI, it will appear lighter and is not copy+pasteable! Dot commands also have special highlighting.

sqlite> .load regex0
sqlite> .header on
sqlite> .mode quote
sqlite> select count(*) from students;
123

xxx