Sometimes I want to insert entire entities into a table, from a SELECT query, including the primary key.[^1] As far as I can tell, this isn't possible with the current insertSelect & Insertion API - the PersistEntity constraint and the types of (<#) and (<&>) get in the way.
The easiest way to support this is probably with an extra insertSelectEntity, to parallel insertEntityMany from Persistent. I haven't yet tried to come up with a safe type for such a function.
[^1]: My use case right now actually involves a REPLACE, as in #86, but it's otherwise the same idea.
Sometimes I want to insert entire entities into a table, from a
SELECTquery, including the primary key.[^1] As far as I can tell, this isn't possible with the currentinsertSelect&InsertionAPI - thePersistEntityconstraint and the types of(<#)and(<&>)get in the way.The easiest way to support this is probably with an extra
insertSelectEntity, to parallelinsertEntityManyfrom Persistent. I haven't yet tried to come up with a safe type for such a function.[^1]: My use case right now actually involves a
REPLACE, as in #86, but it's otherwise the same idea.