Optimized batch insert that minimizes connection idle time. Uses transactions and proper timeouts for better performance.

Filter out duplicate records based on a specified field. Returns {filtered_records, seen_set, duplicate_count}