Skip to content

Support for PostgreSQL 12 jsonpath #1045

Closed as duplicate
Closed as duplicate

Description

@roji

See https://paquier.xyz/postgresql-2/postgres-12-jsonpath

See upcoming jsonpath support in System.Text.Json: dotnet/runtime#31068

Activity

  1. added this to the 3.1.0 milestone on Sep 25, 2019
  2. self-assigned this
    on Sep 25, 2019
  3. modified the milestones: 3.1.0, 5.0.0 on Nov 4, 2019
  4. zakeryooo commented on Aug 2, 2020

    @zakeryooo

    @roji can I ask if this is still potentially planned for 5.0? Is this one of the features that would need to be implemented to query inside jsonb arrays? i.e:

    [Column(TypeName = "jsonb")]
    public List<AnotherClass> Examples { get; set; }
    
    ctx.Items.Where(i => i.Examples.Any(e => e.Capacity >  100))

    I'm building something that will need to search inside quite a large number of jsonb lists so just wondering if this feature is on the horizon or if I should go down the less ideal route of splitting each list into their own table and using normal joins to query the data instead. Thanks!

  5. roji commented on Aug 3, 2020

    @roji
    MemberAuthor

    @zakeryooo there are many translation possibilities with jsonpath, so this could up a pretty big task done incrementally, over several releases. Given where we are and all the other work, I wouldn't depend on jsonpath being implemented for 5.0.

    However, you shouldn't hesitate to use EF Core's raw SQL capability to express jsonpath queries yourself, and possibly compose additional SQL operations over that (plus EF Core will materialize your queries). This can be a very effective way to get the exact results you want, and when jsonpath support comes along you can replace those raw queries.

  6. modified the milestones: 5.0.0, 6.0.0 on Aug 27, 2020
  7. roji commented on Jul 16, 2021

    @roji
    MemberAuthor

    Punting this to work in v7 along with the rest of the JSON support in EF.

  8. modified the milestones: 6.0.0, 7.0.0 on Jul 16, 2021
  9. atrauzzi commented on Sep 29, 2021

    @atrauzzi

    Just chiming in to note that any search capabilities would be awesome if they also had some way to present jsonpath support as well as embedded expression checks.

    Things like where json_column @@ '$.*.*.id !== null and similar. Especially where any functionality would be able to leverage GIN indexes.

  10. roji commented on Sep 29, 2021

    @roji
    MemberAuthor

    Yeah. Some jsonpath improvements are likely coming to System.Text.Json in 7.0, hopefully we can map those APIs to PostgreSQL jsonpath queries. Otherwise we can roll our own custom APIs for translation, though that would be less nice.

  11. modified the milestones: 7.0.0, 8.0.0 on Oct 15, 2022
  12. roji commented on Mar 1, 2023

    @roji
    MemberAuthor

    Duplicate of #2570

  13. removed this from the 8.0.0 milestone on Mar 1, 2023
  14. removed their assignment
    on Mar 1, 2023
  15. added theissue type on Jun 19, 2025
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