1. 5. Prompt
1.1. 2. Distillery
1.1.1. 1. Augmentation
1.2. 4. E-SQL
1.2.1. 5. Question Enrichment Technique
1.2.1.1. 1. Few-Shot Prompting
1.2.1.1.1. 2. Prompt construction
1.3. 7. SuperSQL
1.3.1. 3. Few-Shot Learning
1.4. 4. E-SQL
1.4.1. 2. Candidate SQL Generation (CSG)
1.4.1.1. 1. Prompt Construction
1.4.2. 3. Candidate Predicate Generation
1.4.2.1. 4. Augmenting Prompts for Downstream Tasks
1.4.3. 6. Predicate and Error-Aware SQL Refinement Module (SR)
1.4.3.1. 2. Prompt Construction for Refinement
2. 6. SQL Candidate Generation
2.1. 1. CHASE-SQL
2.1.1. 1. Multi-Path Candidate Generation
2.1.1.1. 1. Divide and Conquer (CoT)
2.1.1.2. 2. Query Plan (CoT)
2.1.1.3. 3. Online Synthetic Example Generation
2.2. 2. Distillery
2.2.1. 2. Selection
2.3. 3. CHESS-SQL
2.3.1. 3. Candidate Generator (CG)
2.3.1.1. 1. generate_candidate_query
2.4. 4. E-SQL
2.4.1. 2. Candidate SQL Generation (CSG)
2.4.1.1. 2. Candidate SQL Generation
2.4.2. 3. Candidate Predicate Generation
2.4.2.1. 3. Candidate Predicate Generation
2.4.3. 6. Predicate and Error-Aware SQL Refinement Module (SR)
2.4.3.1. 3. SQL Refinement or New Query Generation
2.5. 5. RSL-SQL
2.5.1. 3. Binary Selection Strategy (BSS)
2.6. 6. MCS-SQL
2.6.1. 2. Multiple SQL Generation
2.6.1.1. 1. Few-Shot Examples Selection
2.6.1.1.1. 1. Question Similarity Approach
2.6.1.1.2. 2. Masked Question Similarity Approach
2.6.2. 3. Selection
2.6.2.1. 1. Candidate Filtering
3. 7. Query Validation Agents
3.1. 1. CHASE-SQL
3.1.1. 2. Query Fixer (QF)
3.1.2. 3. Selection Agent
3.2. 2. Distillery
3.2.1. 3. Correction
3.3. 3. CHESS-SQL
3.3.1. 3. Candidate Generator (CG)
3.3.1.1. 2. revise
3.4. 3. CHESS-SQL
3.4.1. 4. Unit Tester (UT)
3.4.1.1. 1. generate_unit_test
3.4.1.2. 2. evaluate
3.5. 4. E-SQL
3.5.1. 6. Predicate and Error-Aware SQL Refinement Module (SR)
3.5.1.1. 1. Execution of Candidate SQL Query
3.5.1.2. 4. Validation and Syntax Check
3.6. 5. RSL-SQL
3.6.1. 4. Multi-turn Self Correction (MTSC)
3.6.1.1. 1. Iterative Refinement Process
3.6.1.2. 2. Termination Condition
3.7. 7. SuperSQL
3.7.1. 5. Self-Consistency
3.8. 10. MAC-SQL
3.8.1. 3. Refiner
4. 1. Schema Description
5. 2. Question Understanding
5.1. 1. Rephasing
5.1.1. 2. Distillery
5.1.1.1. 1. Augmentation
5.1.2. 4. E-SQL
5.1.2.1. 5. Question Enrichment Technique
5.1.2.1.1. 3. Enriched Question Generation
5.1.2.1.2. 4. Reasoning Generation
5.1.2.1.3. 5. Fully Enriched Question Generation
5.2. 2. Refactoring
5.2.1. 10. MAC-SQL
5.2.1.1. 2. Decomposer
6. 8. Final SQL Selection/Generation
6.1. 5. RSL-SQL
6.1.1. 2. Contextual Information Augmentation (CIA)
6.1.1.1. 1. SQL Components Generation
6.1.1.2. 2. SQL Generation with Simplified Schema
6.1.2. 3. Binary Selection Strategy (BSS)
6.2. 6. MCS-SQL
6.2.1. 2. Multiple SQL Generation
6.2.1.1. 2. SQL Generation
6.2.2. 3. Selection
6.2.2.1. 2. Multiple-Choice Selection (MCS)
6.3. 7. SuperSQL
6.3.1. 4. SQL Generation
6.3.1.1. 1. Greedy Decoding
6.3.1.2. 2. No Multi-Step Generation or NatSQL
6.4. 8. SFT
6.4.1. 4. SQL Generation
6.5. 9. DTS-SQL
6.5.1. 2. SQLGeneration Fine-tuning
7. 3. Entity Retrieval
7.1. 1. CHASE-SQL
7.1.1. 1. Value Retrieval
7.2. 3. CHESS-SQL
7.2.1. 1. Information Retriever (IR)
7.2.1.1. 1. extract_keywords
7.2.1.2. 2. retrieve_entity
7.2.1.2.1. 1. Locality Sensitive Hashing (LSH)
7.2.1.3. 3. retrieve_context
7.2.1.3.1. 1. Vector Databases
7.3. 4. E-SQL
7.3.1. 1. Databse Description and Value Seelction
7.4. 7. SuperSQL
7.4.1. 2. DB Content
7.5. 8. SFT
7.5.1. 2. Value Retrieval
7.5.2. 3. Metadata Incorporation
7.6. 4. E-SQL
7.6.1. 3. Candidate Predicate Generation
7.6.1.1. 1. Parsing the Candidate SQL
7.6.1.2. 2. Retrieving Potential Values From Database
8. 4. Schema Linking
8.1. 1. Table/Column Linking
8.1.1. 3. CHESS-SQL
8.1.1.1. 2. Schema Selector (SS)
8.1.1.1.1. 1. filter_column
8.1.1.1.2. 2. select_tables
8.1.1.1.3. 3. select_columns
8.1.2. 4. E-SQL
8.1.2.1. 4. Schema Filtering and Filtered Schema Correction Module (SF)
8.1.3. 5. RSL-SQL
8.1.3.1. 1. Bi-Directional Schema Linking
8.1.3.1.1. 1. FSL
8.1.3.1.2. 2. Preliminary SQL Generation
8.1.3.1.3. 3. BSL
8.1.3.1.4. 4. Schema Simplification
8.1.4. 6. MCS-SQL
8.1.4.1. 1. Schema Linking
8.1.4.1.1. 1. Table Linking
8.1.4.1.2. 2. Column Linking
8.1.5. 7. SuperSQL
8.1.5.1. 1. Schema Linking
8.1.6. 8. SFT
8.1.6.1. 1. Schema Filtering
8.1.7. 9. DTS-SQL
8.1.7.1. 1. Schema-linking Fine-tuning
8.1.8. 10. MAC-SQL
8.1.8.1. 1. Selector
8.2. 2. Retrieved Value Linking
8.2.1. 7. SuperSQL
8.2.1.1. 2. DB Content