having to add explicit type casts everywhere is a bit painful, i have a lot of hand-written upserts and use UUIDs everywhere