A SQL ingestion query converts a text value to a number but malformed rows should be quarantined rather than abort the whole batch. Which approach fits?

1. Silently replace every invalid value with zero
2. Treat lexical sorting as numeric validation
3. Discard the whole historical target before validation
4. Use tolerant conversion and route invalid values to an exception path