The Mysterious Behavior of UNION ALL in SQLite: A Deep Dive into Inner Joins and Data Type Conversions