postgresql-for-doctrine

postgresql-for-doctrine copied to clipboard

Allows :dql_parameters with ARRAY_* functions

1

before it was only possible to do `ARRAY_APPEND(e.myarray, 'a_literal')` so it was impossible to have the value coming from php (without resorting to DQL injection) We now allow also the...

allan-simon

support JSON_TABLE

6

Postgres 17 has JSON_TABLE, which looks pretty cool. https://medium.com/@atarax/finally-json-table-is-here-postgres-17-a9b5245649bd

tacman

chore: Update GitHub Actions dependencies

1

This PR contains the following updates: | Package | Type | Update | Change | |---|---|---|---| | [lendable/sloth](https://redirect.github.com/lendable/sloth) | action | patch | `0.2.0` -> `0.2.1` | | [shivammathur/setup-php](https://redirect.github.com/shivammathur/setup-php) |...

renovate[bot]

chore: Update dependency phpunit/phpunit to v12

2

> **Note:** This PR body was truncated due to platform limits. This PR contains the following updates: | Package | Change | [Age](https://docs.renovatebot.com/merge-confidence/) | [Confidence](https://docs.renovatebot.com/merge-confidence/) | |---|---|---|---| | [phpunit/phpunit](https://phpunit.de/) ([source](https://redirect.github.com/sebastianbergmann/phpunit))...

renovate[bot]

I have created a release PR for this version --- ## [3.3.0](https://github.com/martin-georgiev/postgresql-for-doctrine/compare/v3.2.2...v3.3.0) (2025-06-15) ### Features * Add support for formatting functions `to_char`, `to_date`, `to_number`, `to_timestamp` ([#386](https://github.com/martin-georgiev/postgresql-for-doctrine/issues/386)) ([7a047e8](https://github.com/martin-georgiev/postgresql-for-doctrine/commit/7a047e840bd4b1df608eb56ee796d19e209077e8)) --- This PR...

github-actions[bot]

Support PostGIS

8

Hi, It would be nice to have PostGIS support :).

seb-jean

Add Range types

5

This PR complements https://github.com/martin-georgiev/postgresql-for-doctrine/pull/263 that added support for range functions. It adds the support for simple mapping of range types in Doctrine entities. ## Summary by CodeRabbit - **New Features**...

janklan

feat!: change TYPE_NAME visibility

5

Currently, I need to do this in my Doctrine entity: ```php #[ORM\Column(type: 'point')] public PointValueObject $point; ``` It would be interesting to do this: ```php #[ORM\Column(type: Point::TYPE_NAME)] public PointValueObject $point;...

seb-jean

how to check if a JSONB column contains a value -- CONTAINS?

5

I'm sure this is simple, I'll update the docs once I know how to do it. A simple query: ``` $qb = $this->articleRepository->createQueryBuilder('article'); $qb ->andWhere('CONTAINS(article.tagValues, :tagValue) = TRUE') ->setParameter('tagValue', $tagValue)...

tacman

feat: add support for `DATE_TRUNC`

5

The subject says it all. ## Summary by CodeRabbit * **New Features** * Added DATE_TRUNC to truncate timestamps to specified precision with optional timezone support. * **Documentation** * Updated integration...

janklan