Using FlakeId in JSON field
In order to do a join on a json field, we can't store the FlakeId strings, we can only store a UUID string. Eg:
%Example{
id: "A1oBVcaRQRCOdu9tuy",
data: %{
"user_id" => "00000175-d284-af33-8cdd-4241fb990000"
}
}
This makes a join ... on users.id = example.data->>'user_id'::uuid
possible. Wondering if there's a more semantic way to do this.