{"id":"https://openalex.org/W7152612803","doi":"https://doi.org/10.48550/arxiv.2604.06231","title":"Automating Database-Native Function Code Synthesis with LLMs","display_name":"Automating Database-Native Function Code Synthesis with LLMs","publication_year":2026,"publication_date":"2026-04-02","ids":{"openalex":"https://openalex.org/W7152612803","doi":"https://doi.org/10.48550/arxiv.2604.06231"},"language":null,"primary_location":{"id":"doi:10.48550/arxiv.2604.06231","is_oa":true,"landing_page_url":"https://doi.org/10.48550/arxiv.2604.06231","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":false,"raw_source_name":null,"raw_type":"Preprint"},"type":"preprint","indexed_in":["datacite"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"https://doi.org/10.48550/arxiv.2604.06231","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5101764521","display_name":"Wei Zhou","orcid":"https://orcid.org/0000-0003-2787-5045"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Zhou, Wei","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5133247376","display_name":"Xuanhe Zhou","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Zhou, Xuanhe","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5124038443","display_name":"Qikang He","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"He, Qikang","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5133266506","display_name":"Guoliang Li","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Li, Guoliang","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5133271135","display_name":"Bingsheng He","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"He, Bingsheng","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5074979952","display_name":"Quanqing Xu","orcid":"https://orcid.org/0000-0001-8989-9662"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Xu, Quanqing","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"last","author":{"id":"https://openalex.org/A5133249751","display_name":"Fan Wu","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Wu, Fan","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":0,"corresponding_author_ids":[],"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.45239999890327454,"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"}},"topics":[{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.45239999890327454,"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/T10260","display_name":"Software Engineering Research","score":0.11010000109672546,"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/T11719","display_name":"Data Quality and Management","score":0.07699999958276749,"subfield":{"id":"https://openalex.org/subfields/1803","display_name":"Management Science and Operations Research"},"field":{"id":"https://openalex.org/fields/18","display_name":"Decision Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/function","display_name":"Function (biology)","score":0.5062999725341797},{"id":"https://openalex.org/keywords/component","display_name":"Component (thermodynamics)","score":0.4876999855041504},{"id":"https://openalex.org/keywords/context","display_name":"Context (archaeology)","score":0.36309999227523804},{"id":"https://openalex.org/keywords/key","display_name":"Key (lock)","score":0.3564000129699707},{"id":"https://openalex.org/keywords/active-database","display_name":"Active database","score":0.3476000130176544},{"id":"https://openalex.org/keywords/code-generation","display_name":"Code generation","score":0.3357999920845032},{"id":"https://openalex.org/keywords/orchestration","display_name":"Orchestration","score":0.328900009393692},{"id":"https://openalex.org/keywords/leverage","display_name":"Leverage (statistics)","score":0.3206000030040741}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7742000222206116},{"id":"https://openalex.org/C14036430","wikidata":"https://www.wikidata.org/wiki/Q3736076","display_name":"Function (biology)","level":2,"score":0.5062999725341797},{"id":"https://openalex.org/C168167062","wikidata":"https://www.wikidata.org/wiki/Q1117970","display_name":"Component (thermodynamics)","level":2,"score":0.4876999855041504},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.4602000117301941},{"id":"https://openalex.org/C2779343474","wikidata":"https://www.wikidata.org/wiki/Q3109175","display_name":"Context (archaeology)","level":2,"score":0.36309999227523804},{"id":"https://openalex.org/C26517878","wikidata":"https://www.wikidata.org/wiki/Q228039","display_name":"Key (lock)","level":2,"score":0.3564000129699707},{"id":"https://openalex.org/C2778744189","wikidata":"https://www.wikidata.org/wiki/Q4677551","display_name":"Active database","level":2,"score":0.3476000130176544},{"id":"https://openalex.org/C115903868","wikidata":"https://www.wikidata.org/wiki/Q80993","display_name":"Software engineering","level":1,"score":0.33970001339912415},{"id":"https://openalex.org/C133162039","wikidata":"https://www.wikidata.org/wiki/Q1061077","display_name":"Code generation","level":3,"score":0.3357999920845032},{"id":"https://openalex.org/C199168358","wikidata":"https://www.wikidata.org/wiki/Q3367000","display_name":"Orchestration","level":3,"score":0.328900009393692},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.32710000872612},{"id":"https://openalex.org/C153083717","wikidata":"https://www.wikidata.org/wiki/Q6535263","display_name":"Leverage (statistics)","level":2,"score":0.3206000030040741},{"id":"https://openalex.org/C49937458","wikidata":"https://www.wikidata.org/wiki/Q2599292","display_name":"Probabilistic logic","level":2,"score":0.29249998927116394},{"id":"https://openalex.org/C146222976","wikidata":"https://www.wikidata.org/wiki/Q1204997","display_name":"Business logic","level":2,"score":0.2824000120162964},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.273499995470047},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.27309998869895935},{"id":"https://openalex.org/C2776505523","wikidata":"https://www.wikidata.org/wiki/Q4785468","display_name":"Plan (archaeology)","level":2,"score":0.26809999346733093},{"id":"https://openalex.org/C2776760102","wikidata":"https://www.wikidata.org/wiki/Q5139990","display_name":"Code (set theory)","level":3,"score":0.2660999894142151},{"id":"https://openalex.org/C184337299","wikidata":"https://www.wikidata.org/wiki/Q1437428","display_name":"Semantics (computer science)","level":2,"score":0.2648000121116638},{"id":"https://openalex.org/C60048249","wikidata":"https://www.wikidata.org/wiki/Q37437","display_name":"Syntax","level":2,"score":0.26420000195503235},{"id":"https://openalex.org/C25810664","wikidata":"https://www.wikidata.org/wiki/Q44325","display_name":"Ontology","level":2,"score":0.25600001215934753},{"id":"https://openalex.org/C2780598303","wikidata":"https://www.wikidata.org/wiki/Q65921492","display_name":"Flexibility (engineering)","level":2,"score":0.2547000050544739},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.2542000114917755},{"id":"https://openalex.org/C152752567","wikidata":"https://www.wikidata.org/wiki/Q116877","display_name":"Code refactoring","level":3,"score":0.25130000710487366},{"id":"https://openalex.org/C177212765","wikidata":"https://www.wikidata.org/wiki/Q627335","display_name":"Workflow","level":2,"score":0.2500999867916107}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.48550/arxiv.2604.06231","is_oa":true,"landing_page_url":"https://doi.org/10.48550/arxiv.2604.06231","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":"Preprint"}],"best_oa_location":{"id":"doi:10.48550/arxiv.2604.06231","is_oa":true,"landing_page_url":"https://doi.org/10.48550/arxiv.2604.06231","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":false,"raw_source_name":null,"raw_type":"Preprint"},"sustainable_development_goals":[{"display_name":"Reduced inequalities","score":0.7801457643508911,"id":"https://metadata.un.org/sdg/10"}],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":0,"referenced_works":[],"related_works":[],"abstract_inverted_index":{"Database":[0],"systems":[1],"incorporate":[2],"an":[3,27,95,192],"ever-growing":[4],"number":[5],"of":[6,106,210],"functions":[7,234],"in":[8,39,236],"their":[9],"kernels":[10],"(a.k.a.,":[11],"database":[12,32,63,101],"native":[13,33,102],"functions)":[14],"for":[15,30,52,98],"scenarios":[16],"like":[17],"new":[18,233],"application":[19],"support":[20],"and":[21,69,85,124,167,177,187,202,223,230],"business":[22],"migration.":[23],"This":[24],"growth":[25],"causes":[26],"urgent":[28],"demand":[29],"automatic":[31],"function":[34,64,75,80,111,118],"synthesis.":[35],"While":[36],"recent":[37],"advances":[38],"LLM-based":[40,96],"code":[41],"generation":[42],"(e.g.,":[43],"Claude":[44],"Code)":[45],"show":[46,214],"promise,":[47],"they":[48],"are":[49],"too":[50],"generic":[51],"database-specific":[53],"development.":[54],"They":[55],"often":[56],"hallucinate":[57],"or":[58],"overlook":[59],"critical":[60],"context":[61],"because":[62],"synthesis":[65,136],"is":[66],"inherently":[67],"complex":[68],"error-prone,":[70],"where":[71],"synthesizing":[72,100],"a":[73,139,159],"single":[74],"may":[76],"involve":[77],"registering":[78],"multiple":[79],"units,":[81],"linking":[82],"internal":[83],"references,":[84],"implementing":[86],"logic":[87,173],"correctly.":[88],"To":[89],"this":[90],"end,":[91],"we":[92,129],"propose":[93],"DBCooker,":[94],"system":[97],"automatically":[99],"functions.":[103,212],"It":[104],"consists":[105],"three":[107],"components.":[108],"First,":[109],"the":[110,134,207,237],"characterization":[112],"module":[113],"aggregates":[114],"multi-source":[115],"declarations,":[116],"identifies":[117],"units":[119],"that":[120,144,215],"require":[121],"specialized":[122],"coding,":[123],"traces":[125],"cross-unit":[126],"dependencies.":[127],"Second,":[128],"design":[130],"operations":[131,198],"to":[132,170],"address":[133],"main":[135],"challenges:":[137],"(1)":[138],"pseudo-code-based":[140],"coding":[141],"plan":[142],"generator":[143],"constructs":[145],"structured":[146],"implementation":[147],"skeletons":[148],"by":[149,164],"identifying":[150],"key":[151],"elements":[152],"such":[153],"as":[154],"reusable":[155,175],"referenced":[156],"functions;":[157],"(2)":[158],"hybrid":[160],"fill-in-the-blank":[161],"model":[162],"guided":[163],"probabilistic":[165],"priors":[166],"component":[168],"awareness":[169],"integrate":[171],"core":[172],"with":[174,199],"routines;":[176],"(3)":[178],"three-level":[179],"progressive":[180],"validation,":[181],"including":[182],"syntax":[183],"checking,":[184],"standards":[185],"compliance,":[186],"LLM-guided":[188],"semantic":[189],"verification.":[190],"Finally,":[191],"adaptive":[193],"orchestration":[194,208],"strategy":[195],"unifies":[196],"these":[197],"existing":[200],"tools":[201],"dynamically":[203],"sequences":[204],"them":[205],"via":[206],"history":[209],"similar":[211],"Results":[213],"DBCooker":[216],"outperforms":[217],"other":[218],"methods":[219],"on":[220,228],"SQLite,":[221],"PostgreSQL,":[222],"DuckDB":[224],"(34.55%":[225],"higher":[226],"accuracy":[227],"average),":[229],"can":[231],"synthesize":[232],"absent":[235],"latest":[238],"SQLite":[239],"(v3.50).":[240]},"counts_by_year":[],"updated_date":"2026-07-01T06:00:48.157686","created_date":"2026-04-10T00:00:00"}