misformat "->>" (json operation in Sqlite)

[PengjuXu]

steps

run below in Deno (I don't think this is specific to Deno)

import { format as sqlFormat } from "npm:sql-formatter";

// this works in Sqlite
const sqlText = `
select node.text->>'$._meta.id' as id
from node
`
const params = []  // empty

console.log(
  sqlFormat(sqlText, {params: params.map(p=>JSON.stringify(p))})
)
/*
result, "- > >" is error, not work in Sqlite
`
select
  node.text - > > '$._meta.id' as id
from
  node
`
*/

version

└─┬ npm:/sql-formatter@15.8.0 (2.96MB)
  ├── npm:/argparse@2.0.1 (167.53KB)
  └─┬ npm:/nearley@2.20.1 (74.04KB)
    ├── npm:/commander@2.20.3 (60.98KB)
    ├── npm:/moo@0.5.3 (32.04KB)
    ├── npm:/railroad-diagrams@1.0.0 (50.79KB)
    └─┬ npm:/randexp@0.4.6 (12.01KB)
      ├── npm:/discontinuous-range@1.0.0 (10.73KB)
      └── npm:/ret@0.1.15 (17.49KB)

[nene]

Just specify SQLite as the dialect:

sqlFormat(sqlText, {language: "sqlite"})