case insensitive id_column matching and better error-reporting