{"id":"https://openalex.org/W4416034417","doi":"https://doi.org/10.18653/v1/2025.findings-emnlp.1369","title":"Pi-SQL: Enhancing Text-to-SQL with Fine-Grained Guidance from Pivot Programming Languages","display_name":"Pi-SQL: Enhancing Text-to-SQL with Fine-Grained Guidance from Pivot Programming Languages","publication_year":2025,"publication_date":"2025-01-01","ids":{"openalex":"https://openalex.org/W4416034417","doi":"https://doi.org/10.18653/v1/2025.findings-emnlp.1369"},"language":null,"primary_location":{"id":"doi:10.18653/v1/2025.findings-emnlp.1369","is_oa":true,"landing_page_url":"https://doi.org/10.18653/v1/2025.findings-emnlp.1369","pdf_url":"https://aclanthology.org/2025.findings-emnlp.1369.pdf","source":null,"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Findings of the Association for Computational Linguistics: EMNLP 2025","raw_type":"proceedings-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"gold","oa_url":"https://aclanthology.org/2025.findings-emnlp.1369.pdf","any_repository_has_fulltext":null},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5119984808","display_name":"Yongdong chi","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Yongdong Chi","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5101837435","display_name":"Hanqing Wang","orcid":"https://orcid.org/0000-0001-9264-1646"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Hanqing Wang","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5100964777","display_name":"Yun Chen","orcid":"https://orcid.org/0009-0007-3876-2050"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Yun Chen","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5100318832","display_name":"Yang Yan","orcid":"https://orcid.org/0000-0001-7694-2801"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Yan Yang","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5100343820","display_name":"Jian Yang","orcid":"https://orcid.org/0000-0003-1983-012X"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Jian Yang","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"middle","author":{"id":null,"display_name":"Zonghan Yang","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Zonghan Yang","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5027255721","display_name":"Yan Xiao","orcid":"https://orcid.org/0000-0002-2563-083X"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Xiao Yan","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"last","author":{"id":"https://openalex.org/A5100665980","display_name":"GuanHua Chen","orcid":"https://orcid.org/0000-0001-5015-0902"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Guanhua Chen","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":8,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":true,"cited_by_count":0,"citation_normalized_percentile":{"value":0.15714639,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":"25120","last_page":"25144"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10126","display_name":"Logic, programming, and type systems","score":0.3986999988555908,"subfield":{"id":"https://openalex.org/subfields/1702","display_name":"Artificial Intelligence"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},"topics":[{"id":"https://openalex.org/T10126","display_name":"Logic, programming, and type systems","score":0.3986999988555908,"subfield":{"id":"https://openalex.org/subfields/1702","display_name":"Artificial Intelligence"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.1111999973654747,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T13523","display_name":"Mathematics, Computing, and Information Processing","score":0.050599999725818634,"subfield":{"id":"https://openalex.org/subfields/1703","display_name":"Computational Theory and Mathematics"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/fifth-generation-programming-language","display_name":"Fifth-generation programming language","score":0.3637999892234802},{"id":"https://openalex.org/keywords/field","display_name":"Field (mathematics)","score":0.2694999873638153},{"id":"https://openalex.org/keywords/software","display_name":"Software","score":0.2498999983072281},{"id":"https://openalex.org/keywords/natural-language","display_name":"Natural language","score":0.23899999260902405},{"id":"https://openalex.org/keywords/automation","display_name":"Automation","score":0.23270000517368317}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.6262999773025513},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.5360000133514404},{"id":"https://openalex.org/C199305712","wikidata":"https://www.wikidata.org/wiki/Q3205914","display_name":"Fifth-generation programming language","level":3,"score":0.3637999892234802},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.33379998803138733},{"id":"https://openalex.org/C9652623","wikidata":"https://www.wikidata.org/wiki/Q190109","display_name":"Field (mathematics)","level":2,"score":0.2694999873638153},{"id":"https://openalex.org/C115903868","wikidata":"https://www.wikidata.org/wiki/Q80993","display_name":"Software engineering","level":1,"score":0.25999999046325684},{"id":"https://openalex.org/C2777904410","wikidata":"https://www.wikidata.org/wiki/Q7397","display_name":"Software","level":2,"score":0.2498999983072281},{"id":"https://openalex.org/C195324797","wikidata":"https://www.wikidata.org/wiki/Q33742","display_name":"Natural language","level":2,"score":0.23899999260902405},{"id":"https://openalex.org/C115901376","wikidata":"https://www.wikidata.org/wiki/Q184199","display_name":"Automation","level":2,"score":0.23270000517368317},{"id":"https://openalex.org/C184337299","wikidata":"https://www.wikidata.org/wiki/Q1437428","display_name":"Semantics (computer science)","level":2,"score":0.2295999974012375}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.18653/v1/2025.findings-emnlp.1369","is_oa":true,"landing_page_url":"https://doi.org/10.18653/v1/2025.findings-emnlp.1369","pdf_url":"https://aclanthology.org/2025.findings-emnlp.1369.pdf","source":null,"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Findings of the Association for Computational Linguistics: EMNLP 2025","raw_type":"proceedings-article"}],"best_oa_location":{"id":"doi:10.18653/v1/2025.findings-emnlp.1369","is_oa":true,"landing_page_url":"https://doi.org/10.18653/v1/2025.findings-emnlp.1369","pdf_url":"https://aclanthology.org/2025.findings-emnlp.1369.pdf","source":null,"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Findings of the Association for Computational Linguistics: EMNLP 2025","raw_type":"proceedings-article"},"sustainable_development_goals":[],"awards":[],"funders":[{"id":"https://openalex.org/F4320309612","display_name":"Natural Science Foundation of Shanghai","ror":null},{"id":"https://openalex.org/F4320321001","display_name":"National Natural Science Foundation of China","ror":"https://ror.org/01h0zpd94"},{"id":"https://openalex.org/F4320327605","display_name":"Southern University of Science and Technology","ror":null},{"id":"https://openalex.org/F4320335787","display_name":"Fundamental Research Funds for the Central Universities","ror":null},{"id":"https://openalex.org/F4320337111","display_name":"Basic and Applied Basic Research Foundation of Guangdong Province","ror":null}],"has_content":{"grobid_xml":true,"pdf":true},"content_urls":{"pdf":"https://content.openalex.org/works/W4416034417.pdf","grobid_xml":"https://content.openalex.org/works/W4416034417.grobid-xml"},"referenced_works_count":0,"referenced_works":[],"related_works":[],"abstract_inverted_index":{"Text-to-SQL":[0],"transforms":[1],"the":[2,37,42,45,56,66,97,107,137,142,148,152],"user":[3],"queries":[4],"from":[5,116],"natural":[6,67],"language":[7,68],"to":[8,14,27,63,133,157],"executable":[9],"SQL":[10,29,47,71,94,104],"programs,":[11],"enabling":[12],"non-experts":[13],"interact":[15],"with":[16,126],"complex":[17],"databases.Existing":[18],"prompt-based":[19],"methods":[20],"craft":[21],"meticulous":[22],"text":[23],"guidelines":[24,83],"and":[25,44,70,90],"examples":[26],"facilitate":[28],"generation,":[30],"but":[31],"their":[32,85],"accuracy":[33,150],"is":[34],"hindered":[35],"by":[36,119,155],"large":[38],"semantic":[39],"gap":[40],"between":[41,65],"texts":[43],"low-resource":[46],"programs.In":[48],"this":[49],"work,":[50],"we":[51],"propose":[52],"PI-SQL,":[53,145],"which":[54,146],"incorporates":[55],"high-resource":[57],"Python":[58,77,101,109],"program":[59,95,105],"as":[60],"a":[61,127],"pivot":[62],"bridge":[64],"query":[69,111],"program.In":[72],"particular,":[73],"PI-SQL":[74],"first":[75],"generates":[76],"programs":[78],"that":[79],"provide":[80],"fine-grained":[81],"step-by-step":[82],"in":[84],"code":[86],"blocks":[87],"or":[88],"comments,":[89],"then":[91],"produces":[92],"an":[93],"following":[96],"guidance":[98],"of":[99,144,151],"each":[100],"program.The":[102],"final":[103],"matches":[106],"reference":[108],"program's":[110],"results":[112],"and,":[113],"through":[114],"selection":[115],"candidates":[117],"generated":[118],"different":[120],"strategies,":[121],"achieves":[122],"superior":[123],"execution":[124,149],"speed,":[125],"reward-based":[128],"valid":[129],"efficiency":[130],"score":[131],"up":[132,156],"4.55":[134],"higher":[135],"than":[136],"best-performing":[138,153],"baseline.Extensive":[139],"experiments":[140],"demonstrate":[141],"effectiveness":[143],"improves":[147],"baseline":[154],"3.20.":[158]},"counts_by_year":[],"updated_date":"2026-06-11T09:08:48.828518","created_date":"2025-11-08T00:00:00"}