Using compound fields in an IN clause

[chris-martin]

Does esqueleto offer a way to use compound fields in an IN clause? e.g.

SELECT * FROM table_name WHERE (a, b) IN (...);

One would want to write

where_ $ (entity ^. EntityA, entity ^. EntityB) `in_` valList ___

But of course this is not correct, as the left-hand side has type (SqlExpr (Value a), SqlExpr (Value b)) whereas we need SqlExpr (Value (a, b)). It seems to me naively that such a function ought to be possible to define and add amongst the "normal stuff" utilities.

[parsonsmatt]

I would be happy to support this - it would be useful for a lot of things.

[belevy]

Is this syntax supported by multiple databases or just psql? It would require better support for row values as I believe it is essentially syntactic sugar over arrays of rows in postgres.

As a workaround you could always use a correlated sub query that selects from values, it's not ideal for sure but it might solve an immediate problem.