Make sure syntax doesn’t throw error in SQLite
Allow ORDER BY in UNION sub-selects (for databases that support it)

ORDER BY before a UNION can make a difference, for example if you’re doing a DISTINCT query
Also hit MySQL in tests at least once