Google Cloud and Stanford Researchers Propose CHASE-SQL: An AI Framework for Multi-Path Reasoning and Preference Optimized Candidate Selection in Text-to-SQL