Parsing sql query to JSON

Question

I'm looking for a way, preferable an NPM Package, to parse an SQL query to JSON. I found some for SELECT statements, but I actually need for UPDATE and INSERT INTO statements.
For example, a Query in the form of

"UPDATE "users" SET name = $2 where id in ($1)", ['new name', 1]

The result should be something like:

{ 
  action: 'UPDATE',
  entity: 'users',
  values: { name: 'new name' },
  conditions: { 'id': 1} 
}

Thank you for your help!

Serban Petrescu · Accepted Answer · 2019-11-21 08:57:13Z

5

Welcome to StackOverflow!

There are multiple libraries out there for doing this. One example is node-sql-parser. Based on their readme, you can simply do:

const { Parser } = require('node-sql-parser');
const parser = new Parser();
const ast = parser.astify('SELECT * FROM t'); // mysql sql grammer parsed by default

console.log(ast);

And the output would be something like this:

{
  "type": "select",
  "columns": "*",
  "from": [
    {
      "table": "t"
    }
  ]
}

You can play around with it here to see if it matches your expectations: https://npm.runkit.com/node-sql-parser.

answered Nov 21, 2019 at 8:57

Serban Petrescu

5,2062 gold badges20 silver badges37 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Andreas Over a year ago

You've been a member long enough to know that questions for off-site resources, like libraries, is off-topic) for SO. Vote to close accordingly instead of adding an opinion-based recommendation.

Collectives™ on Stack Overflow

Parsing sql query to JSON

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related