SQL/ERR: raise error when insert failed with sqlite fallback (GH8341)

Related to #8341, does not closes it, but deals with the fact that it now fails silently