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.
Does esqueleto offer a way to use compound fields in an
INclause? e.g.One would want to write
But of course this is not correct, as the left-hand side has type
(SqlExpr (Value a), SqlExpr (Value b))whereas we needSqlExpr (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.