{"id":"https://openalex.org/W4413943441","doi":"https://doi.org/10.14778/3742728.3742761","title":"Is Long Context All You Need? Leveraging LLM's Extended Context for NL2SQL","display_name":"Is Long Context All You Need? Leveraging LLM's Extended Context for NL2SQL","publication_year":2025,"publication_date":"2025-04-01","ids":{"openalex":"https://openalex.org/W4413943441","doi":"https://doi.org/10.14778/3742728.3742761"},"language":"en","primary_location":{"id":"doi:10.14778/3742728.3742761","is_oa":false,"landing_page_url":"https://doi.org/10.14778/3742728.3742761","pdf_url":null,"source":{"id":"https://openalex.org/S4210226185","display_name":"Proceedings of the VLDB Endowment","issn_l":"2150-8097","issn":["2150-8097"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the VLDB Endowment","raw_type":"journal-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":false,"oa_status":"closed","oa_url":null,"any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5087758743","display_name":"Yeounoh Chung","orcid":"https://orcid.org/0000-0002-6535-9001"},"institutions":[{"id":"https://openalex.org/I1291425158","display_name":"Google (United States)","ror":"https://ror.org/00njsd438","country_code":"US","type":"company","lineage":["https://openalex.org/I1291425158","https://openalex.org/I4210128969"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Yeounoh Chung","raw_affiliation_strings":["Google"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Google","institution_ids":["https://openalex.org/I1291425158"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5075392841","display_name":"Gaurav Tarlok Kakkar","orcid":"https://orcid.org/0000-0003-2750-5052"},"institutions":[{"id":"https://openalex.org/I1291425158","display_name":"Google (United States)","ror":"https://ror.org/00njsd438","country_code":"US","type":"company","lineage":["https://openalex.org/I1291425158","https://openalex.org/I4210128969"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Gaurav T. Kakkar","raw_affiliation_strings":["Google"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Google","institution_ids":["https://openalex.org/I1291425158"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5039589213","display_name":"Yu Gan","orcid":"https://orcid.org/0000-0002-5769-6809"},"institutions":[{"id":"https://openalex.org/I1291425158","display_name":"Google (United States)","ror":"https://ror.org/00njsd438","country_code":"US","type":"company","lineage":["https://openalex.org/I1291425158","https://openalex.org/I4210128969"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Yu Gan","raw_affiliation_strings":["Google"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Google","institution_ids":["https://openalex.org/I1291425158"]}]},{"author_position":"middle","author":{"id":null,"display_name":"Brenton Milne","orcid":null},"institutions":[{"id":"https://openalex.org/I1291425158","display_name":"Google (United States)","ror":"https://ror.org/00njsd438","country_code":"US","type":"company","lineage":["https://openalex.org/I1291425158","https://openalex.org/I4210128969"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Brenton Milne","raw_affiliation_strings":["Google"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Google","institution_ids":["https://openalex.org/I1291425158"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5070638387","display_name":"Fatma \u00d6zcan","orcid":"https://orcid.org/0000-0002-4418-4724"},"institutions":[{"id":"https://openalex.org/I1291425158","display_name":"Google (United States)","ror":"https://ror.org/00njsd438","country_code":"US","type":"company","lineage":["https://openalex.org/I1291425158","https://openalex.org/I4210128969"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Fatma \u00d6zcan","raw_affiliation_strings":["Google"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Google","institution_ids":["https://openalex.org/I1291425158"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":[],"corresponding_institution_ids":["https://openalex.org/I1291425158"],"apc_list":null,"apc_paid":null,"fwci":6.08,"has_fulltext":false,"cited_by_count":3,"citation_normalized_percentile":{"value":0.96347502,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":96,"max":97},"biblio":{"volume":"18","issue":"8","first_page":"2735","last_page":"2747"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T13999","display_name":"Digital Rights Management and Security","score":0.980400025844574,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"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/T13999","display_name":"Digital Rights Management and Security","score":0.980400025844574,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"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.9135000109672546,"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/context","display_name":"Context (archaeology)","score":0.7376574873924255},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.5129270553588867},{"id":"https://openalex.org/keywords/history","display_name":"History","score":0.16370442509651184},{"id":"https://openalex.org/keywords/archaeology","display_name":"Archaeology","score":0.06738248467445374}],"concepts":[{"id":"https://openalex.org/C2779343474","wikidata":"https://www.wikidata.org/wiki/Q3109175","display_name":"Context (archaeology)","level":2,"score":0.7376574873924255},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.5129270553588867},{"id":"https://openalex.org/C95457728","wikidata":"https://www.wikidata.org/wiki/Q309","display_name":"History","level":0,"score":0.16370442509651184},{"id":"https://openalex.org/C166957645","wikidata":"https://www.wikidata.org/wiki/Q23498","display_name":"Archaeology","level":1,"score":0.06738248467445374}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.14778/3742728.3742761","is_oa":false,"landing_page_url":"https://doi.org/10.14778/3742728.3742761","pdf_url":null,"source":{"id":"https://openalex.org/S4210226185","display_name":"Proceedings of the VLDB Endowment","issn_l":"2150-8097","issn":["2150-8097"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the VLDB Endowment","raw_type":"journal-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":9,"referenced_works":["https://openalex.org/W2890431379","https://openalex.org/W3034835156","https://openalex.org/W4238846128","https://openalex.org/W4317716303","https://openalex.org/W4382202531","https://openalex.org/W4386768923","https://openalex.org/W4391876619","https://openalex.org/W4399115971","https://openalex.org/W4399452982"],"related_works":["https://openalex.org/W4391375266","https://openalex.org/W2899084033","https://openalex.org/W2748952813","https://openalex.org/W2390279801","https://openalex.org/W4391913857","https://openalex.org/W2358668433","https://openalex.org/W4396701345","https://openalex.org/W2376932109","https://openalex.org/W2001405890","https://openalex.org/W4396696052"],"abstract_inverted_index":{"Large":[0],"Language":[1],"Models":[2],"(LLMs)":[3],"have":[4,28],"demonstrated":[5],"impressive":[6],"capabilities":[7],"across":[8,192],"a":[9,54],"range":[10],"of":[11,25,57,89,109,131],"natural":[12,43],"language":[13,44],"processing":[14],"tasks.":[15],"In":[16,78],"particular,":[17],"improvements":[18],"in":[19,40,175],"reasoning":[20],"abilities":[21],"and":[22,61,74,85,118,126,146,159,170],"the":[23,42,50,83,86,90,107,129,136,142,176],"expansion":[24],"context":[26,92,144,166],"windows":[27],"opened":[29],"new":[30],"avenues":[31],"for":[32],"leveraging":[33],"these":[34],"powerful":[35],"models.":[36],"NL2SQL":[37,152,183],"is":[38,46,70,135],"challenging":[39],"that":[41,164],"question":[45,117],"inherently":[47],"ambiguous,":[48],"while":[49],"SQL":[51,119,124],"generation":[52,153],"requires":[53],"precise":[55],"understanding":[56],"complex":[58],"data":[59],"schema":[60],"semantics.":[62],"One":[63],"approach":[64],"to":[65,71,139,156],"this":[66,79,134],"semantic":[67],"ambiguous":[68],"problem":[69],"provide":[72],"more":[73],"sufficient":[75],"contextual":[76,111,148,178],"information.":[77,179],"work,":[80],"we":[81],"explore":[82],"performance":[84,191],"latency":[87,160],"tradeoffs":[88],"extended":[91,143,177],"window":[93,145],"(a.k.a.,":[94],"long":[95,165],"context)":[96],"offered":[97],"by":[98],"Google's":[99,187],"state-of-the-art":[100],"LLM":[101],"(":[102],"gemini-1.5-pro":[103],").":[104],"We":[105,162],"study":[106,140],"impact":[108],"various":[110],"information,":[112],"including":[113],"column":[114],"example":[115],"values,":[116],"query":[120],"pairs,":[121],"user-provided":[122],"hints,":[123],"documentation,":[125],"schema.":[127],"To":[128],"best":[130],"our":[132,181],"knowledge,":[133],"first":[137],"work":[138],"how":[141],"extra":[147],"information":[149],"can":[150],"help":[151],"with":[154],"respect":[155],"both":[157],"accuracy":[158],"cost.":[161],"show":[163],"LLMs":[167],"are":[168],"robust":[169],"do":[171],"not":[172],"get":[173],"lost":[174],"Additionally,":[180],"long-context":[182],"pipeline":[184],"based":[185,201],"on":[186],"Gemini-pro-1.5":[188],"achieves":[189],"strong":[190],"multiple":[193],"benchmark":[194],"datasets":[195],"without":[196],"fine-tuning":[197],"or":[198],"expensive":[199],"self-consistency":[200],"techniques.":[202]},"counts_by_year":[{"year":2025,"cited_by_count":3}],"updated_date":"2026-05-21T06:26:12.895304","created_date":"2025-10-10T00:00:00"}