Parse URL first, then fallback to SQLite special cases (:memory:, .db,
.sqlite) if no scheme found or parse error. Preserves original parse
error for better diagnostics.

Co-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>