{"id":"https://openalex.org/W7139914624","doi":"https://doi.org/10.48550/arxiv.2603.18606","title":"SQL-Commenter: Aligning Large Language Models for SQL Comment Generation with Direct Preference Optimization","display_name":"SQL-Commenter: Aligning Large Language Models for SQL Comment Generation with Direct Preference Optimization","publication_year":2026,"publication_date":"2026-03-19","ids":{"openalex":"https://openalex.org/W7139914624","doi":"https://doi.org/10.48550/arxiv.2603.18606"},"language":null,"primary_location":{"id":"doi:10.48550/arxiv.2603.18606","is_oa":true,"landing_page_url":"https://doi.org/10.48550/arxiv.2603.18606","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.2603.18606","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5130243007","display_name":"Lei Yu","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Yu, Lei","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5130232069","display_name":"Peng Wang","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Wang, Peng","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5130226603","display_name":"Jingyuan Zhang","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Zhang, Jingyuan","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5130230294","display_name":"Xin Eric Wang","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Wang, Xin","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5130228025","display_name":"Jia Xu","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Xu, Jia","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5130223430","display_name":"Li Yang","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Yang, Li","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5059773584","display_name":"Changzhi Deng","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Deng, Changzhi","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5130244214","display_name":"Jiajia Ma","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Ma, Jiajia","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"last","author":{"id":"https://openalex.org/A5101846515","display_name":"Fengjun Zhang","orcid":"https://orcid.org/0000-0002-3830-8786"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Zhang, Fengjun","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":1,"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.2815000116825104,"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.2815000116825104,"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.20350000262260437,"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/T10215","display_name":"Semantic Web and Ontologies","score":0.11240000277757645,"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/sql","display_name":"SQL","score":0.7929999828338623},{"id":"https://openalex.org/keywords/syntax","display_name":"Syntax","score":0.5246999859809875},{"id":"https://openalex.org/keywords/data-definition-language","display_name":"Data definition language","score":0.48840001225471497},{"id":"https://openalex.org/keywords/code","display_name":"Code (set theory)","score":0.4083000123500824},{"id":"https://openalex.org/keywords/quality","display_name":"Quality (philosophy)","score":0.37929999828338623},{"id":"https://openalex.org/keywords/language-integrated-query","display_name":"Language Integrated Query","score":0.357699990272522},{"id":"https://openalex.org/keywords/construct","display_name":"Construct (python library)","score":0.349700003862381},{"id":"https://openalex.org/keywords/semantics","display_name":"Semantics (computer science)","score":0.34540000557899475}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.835099995136261},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.7929999828338623},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.5321999788284302},{"id":"https://openalex.org/C60048249","wikidata":"https://www.wikidata.org/wiki/Q37437","display_name":"Syntax","level":2,"score":0.5246999859809875},{"id":"https://openalex.org/C55596503","wikidata":"https://www.wikidata.org/wiki/Q1431648","display_name":"Data definition language","level":3,"score":0.48840001225471497},{"id":"https://openalex.org/C204321447","wikidata":"https://www.wikidata.org/wiki/Q30642","display_name":"Natural language processing","level":1,"score":0.44780001044273376},{"id":"https://openalex.org/C2776760102","wikidata":"https://www.wikidata.org/wiki/Q5139990","display_name":"Code (set theory)","level":3,"score":0.4083000123500824},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.3919999897480011},{"id":"https://openalex.org/C119857082","wikidata":"https://www.wikidata.org/wiki/Q2539","display_name":"Machine learning","level":1,"score":0.39089998602867126},{"id":"https://openalex.org/C2779530757","wikidata":"https://www.wikidata.org/wiki/Q1207505","display_name":"Quality (philosophy)","level":2,"score":0.37929999828338623},{"id":"https://openalex.org/C179531526","wikidata":"https://www.wikidata.org/wiki/Q595637","display_name":"Language Integrated Query","level":5,"score":0.357699990272522},{"id":"https://openalex.org/C2780801425","wikidata":"https://www.wikidata.org/wiki/Q5164392","display_name":"Construct (python library)","level":2,"score":0.349700003862381},{"id":"https://openalex.org/C184337299","wikidata":"https://www.wikidata.org/wiki/Q1437428","display_name":"Semantics (computer science)","level":2,"score":0.34540000557899475},{"id":"https://openalex.org/C137293760","wikidata":"https://www.wikidata.org/wiki/Q3621696","display_name":"Language model","level":2,"score":0.32519999146461487},{"id":"https://openalex.org/C56288433","wikidata":"https://www.wikidata.org/wiki/Q58673","display_name":"Data manipulation language","level":2,"score":0.3244999945163727},{"id":"https://openalex.org/C154420247","wikidata":"https://www.wikidata.org/wiki/Q846619","display_name":"Stored procedure","level":5,"score":0.32350000739097595},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.3122999966144562},{"id":"https://openalex.org/C195324797","wikidata":"https://www.wikidata.org/wiki/Q33742","display_name":"Natural language","level":2,"score":0.31189998984336853},{"id":"https://openalex.org/C2777561058","wikidata":"https://www.wikidata.org/wiki/Q2652119","display_name":"Program comprehension","level":4,"score":0.29919999837875366},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.29490000009536743},{"id":"https://openalex.org/C167544706","wikidata":"https://www.wikidata.org/wiki/Q360842","display_name":"SQL/PSM","level":5,"score":0.29409998655319214},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.28450000286102295},{"id":"https://openalex.org/C67186912","wikidata":"https://www.wikidata.org/wiki/Q367664","display_name":"Data modeling","level":2,"score":0.27489998936653137},{"id":"https://openalex.org/C58646249","wikidata":"https://www.wikidata.org/wiki/Q127380","display_name":"Abstract syntax tree","level":3,"score":0.2644999921321869},{"id":"https://openalex.org/C2781249084","wikidata":"https://www.wikidata.org/wiki/Q908656","display_name":"Preference","level":2,"score":0.2639000117778778},{"id":"https://openalex.org/C511192102","wikidata":"https://www.wikidata.org/wiki/Q5156948","display_name":"Comprehension","level":2,"score":0.25699999928474426},{"id":"https://openalex.org/C136389625","wikidata":"https://www.wikidata.org/wiki/Q334384","display_name":"Supervised learning","level":3,"score":0.25270000100135803}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.48550/arxiv.2603.18606","is_oa":true,"landing_page_url":"https://doi.org/10.48550/arxiv.2603.18606","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.2603.18606","is_oa":true,"landing_page_url":"https://doi.org/10.48550/arxiv.2603.18606","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":[{"score":0.4318021237850189,"display_name":"Quality Education","id":"https://metadata.un.org/sdg/4"}],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":0,"referenced_works":[],"related_works":[],"abstract_inverted_index":{"SQL":[0,31,72,97,110],"query":[1],"comprehension":[2],"is":[3],"a":[4,92,108,136],"significant":[5],"challenge":[6],"due":[7],"to":[8,112,140],"complex":[9,43,71,96],"syntax,":[10],"diverse":[11],"join":[12],"types,":[13],"and":[14,27,46,65,117,148,156,175,182,202],"deep":[15],"nesting.":[16],"Many":[17],"queries":[18,98],"lack":[19],"adequate":[20],"comments,":[21],"severely":[22],"hindering":[23],"code":[24],"readability,":[25],"maintainability,":[26],"knowledge":[28],"transfer.":[29],"Automated":[30],"comment":[32],"generation":[33],"faces":[34],"two":[35],"main":[36],"challenges:":[37],"limited":[38],"datasets":[39],"that":[40,60],"inadequately":[41],"represent":[42],"real-world":[44],"queries,":[45],"Large":[47],"Language":[48],"Models'":[49],"(LLMs)":[50],"insufficient":[51],"understanding":[52],"of":[53,95,192,199],"SQL-specific":[54],"semantics.":[55],"Our":[56],"empirical":[57],"analysis":[58],"shows":[59],"even":[61],"after":[62],"continual":[63,105],"pre-training":[64,106],"supervised":[66,122],"fine-tuning,":[67],"LLMs":[68],"struggle":[69],"with":[70,99],"semantics,":[73],"yielding":[74],"inaccurate":[75],"comments.":[76,101],"To":[77],"address":[78],"this,":[79],"we":[80,103,125],"propose":[81],"SQL-Commenter,":[82],"an":[83],"advanced":[84],"method":[85],"based":[86],"on":[87,107,153,179],"LLaMA-3.1-8B.":[88],"We":[89],"first":[90],"construct":[91],"comprehensive":[93],"dataset":[94],"expert-verified":[100],"Next,":[102],"perform":[104],"large":[109],"corpus":[111],"enhance":[113],"the":[114,154,168,189],"LLM's":[115],"syntax":[116],"semantic":[118,146],"understanding,":[119],"followed":[120],"by":[121,172,195],"fine-tuning.":[123],"Finally,":[124],"introduce":[126],"Direct":[127],"Preference":[128],"Optimization":[129],"(DPO)":[130],"using":[131],"human":[132,186],"feedback.":[133],"SQL-Commenter":[134,159,196],"utilizes":[135],"preference-based":[137],"loss":[138],"function":[139],"favor":[141],"preferred":[142],"outputs,":[143],"enhancing":[144],"fine-grained":[145],"learning":[147],"context-dependent":[149],"quality":[150,191],"assessment.":[151],"Evaluated":[152],"Spider":[155],"Bird":[157],"benchmarks,":[158],"significantly":[160],"outperforms":[161],"state-of-the-art":[162],"baselines.":[163],"On":[164],"average,":[165],"it":[166],"surpasses":[167],"strongest":[169],"baseline":[170],"(Qwen3-14B)":[171],"9.29,":[173],"4.99,":[174],"13.23":[176],"percentage":[177],"points":[178],"BLEU-4,":[180],"METEOR,":[181],"ROUGE-L,":[183],"respectively.":[184],"Moreover,":[185],"evaluation":[187],"demonstrates":[188],"superior":[190],"comments":[193],"generated":[194],"in":[197],"terms":[198],"correctness,":[200],"completeness,":[201],"naturalness.":[203]},"counts_by_year":[{"year":2026,"cited_by_count":1}],"updated_date":"2026-07-01T06:00:48.157686","created_date":"2026-03-21T00:00:00"}