db-json-column

JSON column support for Knex and TypeORM

Usage no npm install needed!

<script type="module">
  import dbJsonColumn from 'https://cdn.skypack.dev/db-json-column';
</script>

README

db-json-column image test

If you need to query JSON columns with your Query Builder and Connection Pool without writing raw SQL, this package is for you.

Knex example

await updateJson(knex, knex(tableName).where('id', 1), ['data.foo'], { data: { foo: 'bar' } })

// { data: { foo: 'bar' } }
await selectAndParseJson(knex, knex(tableName), ['data.foo'])

TypeORM example

await updateJson(
  repository.createQueryBuilder().update().where({ id: 1 }),
  ['data.foo'],
  { data: { foo: 'bar' } },
)

// { data: { foo: 'bar' } }
await selectAndParseJson(repository.createQueryBuilder(), ['data.foo'])

Table of contents