row constructors multi fields in() #7118

New Issue

admin · 2026-01-22T15:45:05+01:00

admin commented

2026-01-22 15:45:05 +01:00

Originally created by @revilon1991 on GitHub (Mar 9, 2023).

Feature Request

Hello, it seems to me that we don't have the feature row constructors in the query builder.
Why?

Q	A
New Feature	yes
RFC	yes

Summary

For example, we can do this query as a clean SQL like as:

select *
from User u
where (u.country, u.city) in (
    ('Cyprus', 'Limassol'),
    ('Netherlands', 'Amsterdam')
)

And we could get all users who live in Cyprus, Limassol and who live in The Netherlands, Amsterdam.

Sometimes this construction calls "row constructors".
I can help to develop that and make PR if you wish.

More information have in MySQL docs

Originally created by @revilon1991 on GitHub (Mar 9, 2023). ### Feature Request Hello, it seems to me that we don't have the feature row constructors in the query builder. Why? | Q | A |------------ | ------ | New Feature | yes | RFC | yes #### Summary For example, we can do this query as a clean SQL like as: ```sql select * from User u where (u.country, u.city) in ( ('Cyprus', 'Limassol'), ('Netherlands', 'Amsterdam') ) ``` And we could get all users who live in Cyprus, Limassol and who live in The Netherlands, Amsterdam. Sometimes this construction calls "row constructors". I can help to develop that and make PR if you wish. More information have in MySQL [docs](https://dev.mysql.com/doc/refman/8.0/en/comparison-operators.html#operator_in)

admin added the New Feature label 2026-01-22 15:45:05 +01:00

admin commented

2026-01-22 15:45:06 +01:00

@derrabus commented on GitHub (Mar 13, 2023):

Hello, it seems to me that we don't have the feature row constructors in the query builder. Why?

Probably because nobody has built that yet. Feel free to give it a try if you need this feature.

@derrabus commented on GitHub (Mar 13, 2023): > Hello, it seems to me that we don't have the feature row constructors in the query builder. Why? Probably because nobody has built that yet. Feel free to give it a try if you need this feature.

Sign in to join this conversation.

Branches Tags

1 Participants

Notifications

Due Date

No due date set.

Dependencies

No dependencies set.

Reference: doctrine/archived-orm#7118