Skip to content

sqlite/json: support -> and ->> operators #2919

Closed
@runsisi

Description

@runsisi

What do you want to change?

Beginning with SQLite version 3.38.0 (2022-02-22), the -> and ->> operators are available for extracting subcomponents of JSON.1

seems the latest sqlc v1.23 release does not support it:

https://play.sqlc.dev/p/25c82bb68f7a141175f4e51fd58047e1dc1466f61e02d059f5dcd6edf06a04d3

What database engines need to be changed?

SQLite

What programming language backends need to be changed?

Go

Footnotes

  1. 4.6. The -> and ->> operators
    https://www.sqlite.org/json1.html#jptr

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions