Chase-sql: Multi-path reasoning and preference optimized candidate selection in text-to-sql