01-27-2026, 08:52 AM
WITH does seem rather unpleasant, surely an ALIAS construct would be nicer:
Where "ent" is effectively replaced by database(id).entity
Code: (Select All)
ALIAS ent TO database(id).entity
ent.name = "Foo"
ent.kind = "Thing"Where "ent" is effectively replaced by database(id).entity

