Like a lot of people, and especially coming from postgres, I recoiled from it at first. In practice it has never caused me a significant issue that I can recal

Like a lot of people, and especially coming from postgres, I recoiled from it at first. In practice it has never caused me a significant issue that I can recall and saves a lot of time casting things into compatible columns for exploratory queries. I'm still not sure I like it. But shifting into sqlite mindset is important for making the most of sqlite's strengths, and learning to think of these as "affinities" rather than types or constraints has been part of that.