I've found the exact opposite to be true. With Postgresql, for example, strong types can be enforced through the entire application stack using tools like Opale

I've found the exact opposite to be true. With Postgresql, for example, strong types can be enforced through the entire application stack using tools like Opaleye. Check out composite types in Postgres and Opaleye to see what I'm talking about.