SQL to JSON

Convert SQL CREATE/INSERT to JSON.

SQL (CREATE / INSERT)

JSON

{
  "users": {
    "columns": [
      {
        "name": "id",
        "type": "INT",
        "nullable": true,
        "primaryKey": true
      },
      {
        "name": "name",
        "type": "VARCHAR",
        "nullable": false,
        "primaryKey": false
      },
      {
        "name": "active",
        "type": "BOOLEAN",
        "nullable": true,
        "primaryKey": false
      }
    ],
    "rows": [
      {
        "id": 1,
        "name": "Ada",
        "active": true
      },
      {
        "id": 2,
        "name": "Linus",
        "active": false
      }
    ]
  }
}