pg_graphql

Changes in this Release

• Support for filtering on array column types

Changes in this Release

• Bugfix: once a query panics, all subsequent queries return a lock poisoned error.

Changes in this Release

• Bugfix: computed field returning a composite type was always null

Changes in this Release

• First Change
• Second Change

• Reimplemented field merging

• Reverts field merging due performance impact on large schema/queries

Note:
This is a pre-release bugfix version intended for users who have encountered slow introspection queries. Reverting field merging is a breaking change which will be addressed before the final 1.5.1 release.

• feature: first/offset based pagination
• feature: improved descriptions for all internal error states

bugfix: function returning a noncompliant view's type no longer breaks introspection

• bugfix: make non-default args non-null in UDFs
• bugfix: default value of a string type argument in a UDF was wrapped in single quotes
• feature: add support for array types in UDFs
• bugfix: fix crash when there are cycles in fragments
• bugfix: function returning an inaccessible table's type no longer breaks introspection

bugfix: UDF call returned null if the row returned by the function had any null column

• feature: Support for user defined functions with default arguments
• bugfix: Trigger functions excluded from API

• feature: citext type represented as a GraphQL String
• feature: Support for Postgres 16
• feature: Support for user defined functions

• feature: rename enum variants with comment directive @graphql({"mappings": "sql-value": "graphql_value""})
• bugfix: query with more than 50 fields fails
• bugfix: @skip and @include directives missing from introspection schema
• feature: Support for and, or and not operators in filters

• bugfix: enums not on the roles search_path are excluded from introspection
• bugfix: remove duplicate Enum registration
• bugfix: foreign keys on non-null columns produce non-null GraphQL relationships

RELEASE NOT RECOMMENDED use v1.2.3

• feature: reproducible builds

RELEASE NOT RECOMMENDED use v1.2.3

• feature: String type filters support regex, iregex
• feature: computed relationships via functions returning setof
• bugfix: function based computed columns with same name no longer error

• feature: String type filters support ilike, like, startsWith
• feature: Support for @skip and @include directives
• feature: Custom descriptions via comment directive @graphql({"description": ...})
• bugfix: Unknown types are represented in GraphQL schema as Opaque rather than String
• bugfix: PostgreSQL type modifiers, e.g. char(n), no longer truncate excess text
• bugfix: Creating a new enum variant between existing variants no longer errors

• feature: Add support for Views, Materialized Views, and Foreign Tables
• feature: Add support for filtering on is null and is not null
• feature: User configurable page size
• bugfix: Remove requirement for insert permission on every column for inserts to succeed
• bugfix: hasNextPage and hasPreviousPage during reverse pagination were backwards

• bugfix: Correct inconsistent treatment of null literals

• feature: Add support for Postgres 15