Investigate schema relations bug in Distribution in aws_cloudfront

[depombo]

We are getting stopgap lazy loader issues here. It could be as simple as having an optional AWS field as not nullable, but could be something else

https://discord.com/channels/920684574231646229/1086405212958380103

[aguillenv]

So I've been trying to reproduce and I've seen some issues but I have not been able to reproduce the main error that was during the sync apparently. Some of the small task and/or issues seen on my branch cf-dist:

• Try to replicate a failure syncing the distributions
• callerReference is set to nullable but it is not
• if you tried to create a distribution with an empty json for the mandatory fields it fails on creation. I think that should be handled properly in the mapper. or maybe a trigger? I need to understand better cf distributions.
• There's an issue with the revert logic :/ specifically for type json fields. The query generated is not setting the type properly. I think I've solved this for the get_sql_* RPCs but they do not use the same code. Maybe I should find a way to make them share as much as possible for this logic...