{"id":"https://openalex.org/W4298181730","doi":"https://doi.org/10.48550/arxiv.2209.14415","title":"Improving Text-to-SQL Semantic Parsing with Fine-grained Query Understanding","display_name":"Improving Text-to-SQL Semantic Parsing with Fine-grained Query Understanding","publication_year":2022,"publication_date":"2022-09-28","ids":{"openalex":"https://openalex.org/W4298181730","doi":"https://doi.org/10.48550/arxiv.2209.14415"},"language":"en","primary_location":{"id":"pmh:oai:arXiv.org:2209.14415","is_oa":true,"landing_page_url":"http://arxiv.org/abs/2209.14415","pdf_url":"https://arxiv.org/pdf/2209.14415","source":{"id":"https://openalex.org/S4306400194","display_name":"arXiv (Cornell University)","issn_l":null,"issn":null,"is_oa":true,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I205783295","host_organization_name":"Cornell University","host_organization_lineage":["https://openalex.org/I205783295"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":"text"},"type":"preprint","indexed_in":["arxiv","datacite"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"https://arxiv.org/pdf/2209.14415","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5100384838","display_name":"Jun Wang","orcid":"https://orcid.org/0000-0002-9515-076X"},"institutions":[],"countries":[],"is_corresponding":true,"raw_author_name":"Wang, Jun","raw_affiliation_strings":[],"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5102761306","display_name":"Patrick Ng","orcid":"https://orcid.org/0000-0001-8208-652X"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Ng, Patrick","raw_affiliation_strings":[],"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5039584843","display_name":"Alexander Hanbo Li","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Li, Alexander Hanbo","raw_affiliation_strings":[],"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5055815844","display_name":"Jiarong Jiang","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Jiang, Jiarong","raw_affiliation_strings":[],"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5100430087","display_name":"Zhiguo Wang","orcid":"https://orcid.org/0000-0002-2412-6172"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Wang, Zhiguo","raw_affiliation_strings":[],"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5109250040","display_name":"Ramesh Nallapati","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Nallapati, Ramesh","raw_affiliation_strings":[],"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5107249743","display_name":"Bing Xiang","orcid":"https://orcid.org/0009-0006-4028-4935"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Xiang, Bing","raw_affiliation_strings":[],"affiliations":[]},{"author_position":"last","author":{"id":"https://openalex.org/A5091546931","display_name":"Sudipta Sengupta","orcid":"https://orcid.org/0009-0001-6331-9524"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Sengupta, Sudipta","raw_affiliation_strings":[],"affiliations":[]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":8,"corresponding_author_ids":["https://openalex.org/A5100384838"],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":null,"has_fulltext":false,"cited_by_count":0,"citation_normalized_percentile":null,"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":null,"last_page":null},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10181","display_name":"Natural Language Processing Techniques","score":0.9966999888420105,"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/T10181","display_name":"Natural Language Processing Techniques","score":0.9966999888420105,"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/T10028","display_name":"Topic Modeling","score":0.9871000051498413,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.9191873073577881},{"id":"https://openalex.org/keywords/parsing","display_name":"Parsing","score":0.5702060461044312},{"id":"https://openalex.org/keywords/natural-language-processing","display_name":"Natural language processing","score":0.5671316385269165},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.5133349299430847},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.5028223395347595},{"id":"https://openalex.org/keywords/top-down-parsing","display_name":"Top-down parsing","score":0.47415345907211304},{"id":"https://openalex.org/keywords/query-language","display_name":"Query language","score":0.46078622341156006},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.4156377911567688},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.4113664925098419},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.3915979266166687}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.9191873073577881},{"id":"https://openalex.org/C186644900","wikidata":"https://www.wikidata.org/wiki/Q194152","display_name":"Parsing","level":2,"score":0.5702060461044312},{"id":"https://openalex.org/C204321447","wikidata":"https://www.wikidata.org/wiki/Q30642","display_name":"Natural language processing","level":1,"score":0.5671316385269165},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.5133349299430847},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.5028223395347595},{"id":"https://openalex.org/C42560504","wikidata":"https://www.wikidata.org/wiki/Q15419395","display_name":"Top-down parsing","level":3,"score":0.47415345907211304},{"id":"https://openalex.org/C192028432","wikidata":"https://www.wikidata.org/wiki/Q845739","display_name":"Query language","level":2,"score":0.46078622341156006},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.4156377911567688},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.4113664925098419},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.3915979266166687}],"mesh":[],"locations_count":2,"locations":[{"id":"pmh:oai:arXiv.org:2209.14415","is_oa":true,"landing_page_url":"http://arxiv.org/abs/2209.14415","pdf_url":"https://arxiv.org/pdf/2209.14415","source":{"id":"https://openalex.org/S4306400194","display_name":"arXiv (Cornell University)","issn_l":null,"issn":null,"is_oa":true,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I205783295","host_organization_name":"Cornell University","host_organization_lineage":["https://openalex.org/I205783295"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":"text"},{"id":"doi:10.48550/arxiv.2209.14415","is_oa":true,"landing_page_url":"https://doi.org/10.48550/arxiv.2209.14415","pdf_url":null,"source":{"id":"https://openalex.org/S4306400194","display_name":"arXiv (Cornell University)","issn_l":null,"issn":null,"is_oa":true,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I205783295","host_organization_name":"Cornell University","host_organization_lineage":["https://openalex.org/I205783295"],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":null,"is_accepted":false,"is_published":null,"raw_source_name":null,"raw_type":"article"}],"best_oa_location":{"id":"pmh:oai:arXiv.org:2209.14415","is_oa":true,"landing_page_url":"http://arxiv.org/abs/2209.14415","pdf_url":"https://arxiv.org/pdf/2209.14415","source":{"id":"https://openalex.org/S4306400194","display_name":"arXiv (Cornell University)","issn_l":null,"issn":null,"is_oa":true,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I205783295","host_organization_name":"Cornell University","host_organization_lineage":["https://openalex.org/I205783295"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":"text"},"sustainable_development_goals":[{"id":"https://metadata.un.org/sdg/4","score":0.6299999952316284,"display_name":"Quality Education"}],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":0,"referenced_works":[],"related_works":["https://openalex.org/W3143982968","https://openalex.org/W2804916787","https://openalex.org/W2159707670","https://openalex.org/W2952780262","https://openalex.org/W3088470625","https://openalex.org/W4388176285","https://openalex.org/W1929722976","https://openalex.org/W2556786504","https://openalex.org/W2389755172","https://openalex.org/W4320024782"],"abstract_inverted_index":{"Most":[0],"recent":[1],"research":[2],"on":[3,8,61,92,160,165,181],"Text-to-SQL":[4],"semantic":[5,32,86,113,149,170],"parsing":[6,87,171],"relies":[7],"either":[9],"parser":[10,39,114],"itself":[11],"or":[12],"simple":[13],"heuristic":[14],"based":[15,91,159],"approach":[16],"to":[17,37,42,67,138],"understand":[18],"natural":[19],"language":[20],"query":[21,51,55,95,119],"(NLQ).":[22],"When":[23],"synthesizing":[24],"a":[25,82,167],"SQL":[26,157],"query,":[27],"there":[28],"is":[29,90],"no":[30],"explicit":[31],"information":[33,150],"of":[34,75,100],"NLQ":[35],"available":[36,148],"the":[38,131,188],"which":[40,65,186],"leads":[41,66],"undesirable":[43],"generalization":[44],"performance.":[45],"In":[46,73],"addition,":[47],"without":[48],"lexical-level":[49],"fine-grained":[50,94],"understanding,":[52],"linking":[53,152],"between":[54],"and":[56,111,120,127,140,151,154],"database":[57],"can":[58,176],"only":[59],"rely":[60],"fuzzy":[62],"string":[63],"match":[64],"suboptimal":[68],"performance":[69],"in":[70,77,130,143],"real":[71],"applications.":[72],"view":[74],"this,":[76],"this":[78],"paper":[79],"we":[80,175],"present":[81],"general-purpose,":[83],"modular":[84],"neural":[85,107,112],"framework":[88,98],"that":[89,174],"token-level":[93],"understanding.":[96],"Our":[97],"consists":[99],"three":[101],"modules:":[102],"named":[103],"entity":[104,108],"recognizer":[105],"(NER),":[106],"linker":[109],"(NEL)":[110],"(NSP).":[115],"By":[116],"jointly":[117],"modeling":[118],"database,":[121],"NER":[122],"model":[123,134,146,190],"analyzes":[124],"user":[125],"intents":[126],"identifies":[128],"entities":[129,137],"query.":[132],"NEL":[133],"links":[135],"typed":[136],"schema":[139],"cell":[141],"values":[142],"database.":[144],"Parser":[145],"leverages":[147],"results":[153],"synthesizes":[155],"tree-structured":[156],"queries":[158],"dynamically":[161],"generated":[162],"grammar.":[163],"Experiments":[164],"SQUALL,":[166],"newly":[168],"released":[169],"dataset,":[172],"show":[173],"achieve":[177],"56.8%":[178],"execution":[179],"accuracy":[180],"WikiTableQuestions":[182],"(WTQ)":[183],"test":[184],"set,":[185],"outperforms":[187],"state-of-the-art":[189],"by":[191],"2.7%.":[192]},"counts_by_year":[],"updated_date":"2026-03-10T16:38:18.471706","created_date":"2025-10-10T00:00:00"}