Skip to content

SQL/JSONPath support #163

Open
Open

Description

@mattbishop

SQL/JSONPath, part of SQL 2016, is a simplification of JSON Path that removes recursive descent (..), replaces negative array seeking with last and remakes array length to size(). An older writeup is here: https://modern-sql.com/blog/2017-06/whats-new-in-sql-2016#json-path

Activity

  1. mattbishop commented on Jul 27, 2021

    @mattbishop
    Author

    Also, it separates the path from the value filter.

    $.store.book[?(@.price<10)]

    becomes

    $.store.book[*].price ? (@ < 10)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions