{"id":"https://openalex.org/W7162405629","doi":"https://doi.org/10.1145/3788853.3803091","title":"SQLens: Continuous Code-to-SQL Visibility in the Wild","display_name":"SQLens: Continuous Code-to-SQL Visibility in the Wild","publication_year":2026,"publication_date":"2026-05-26","ids":{"openalex":"https://openalex.org/W7162405629","doi":"https://doi.org/10.1145/3788853.3803091"},"language":null,"primary_location":{"id":"doi:10.1145/3788853.3803091","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3788853.3803091","pdf_url":null,"source":null,"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Companion of the International Conference on Management of Data","raw_type":"proceedings-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"gold","oa_url":"https://doi.org/10.1145/3788853.3803091","any_repository_has_fulltext":null},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5137033480","display_name":"Xiao Yang","orcid":"https://orcid.org/0009-0004-8636-5875"},"institutions":[{"id":"https://openalex.org/I45928872","display_name":"Alibaba Group (China)","ror":"https://ror.org/00k642b80","country_code":"CN","type":"company","lineage":["https://openalex.org/I45928872"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Xiao Yang","raw_affiliation_strings":["Alibaba Cloud, Hangzhou, China"],"raw_orcid":"https://orcid.org/0009-0004-8636-5875","affiliations":[{"raw_affiliation_string":"Alibaba Cloud, Hangzhou, China","institution_ids":["https://openalex.org/I45928872"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5137013859","display_name":"Mo Sha","orcid":"https://orcid.org/0000-0001-6876-9463"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Mo Sha","raw_affiliation_strings":["Alibaba Cloud, Singapore, Singapore"],"raw_orcid":"https://orcid.org/0000-0001-6876-9463","affiliations":[{"raw_affiliation_string":"Alibaba Cloud, Singapore, Singapore","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5100427538","display_name":"Yiran Li","orcid":"https://orcid.org/0000-0001-8236-792X"},"institutions":[{"id":"https://openalex.org/I45928872","display_name":"Alibaba Group (China)","ror":"https://ror.org/00k642b80","country_code":"CN","type":"company","lineage":["https://openalex.org/I45928872"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Yiran Li","raw_affiliation_strings":["Alibaba Cloud, Beijing, China"],"raw_orcid":"https://orcid.org/0009-0008-2378-6284","affiliations":[{"raw_affiliation_string":"Alibaba Cloud, Beijing, China","institution_ids":["https://openalex.org/I45928872"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5102801704","display_name":"Shian Zhong","orcid":"https://orcid.org/0009-0003-0341-7362"},"institutions":[{"id":"https://openalex.org/I165932596","display_name":"National University of Singapore","ror":"https://ror.org/01tgyzw49","country_code":"SG","type":"education","lineage":["https://openalex.org/I165932596"]}],"countries":["SG"],"is_corresponding":false,"raw_author_name":"Suyang Zhong","raw_affiliation_strings":["National University of Singapore, Singapore, Singapore"],"raw_orcid":"https://orcid.org/0009-0003-0341-7362","affiliations":[{"raw_affiliation_string":"National University of Singapore, Singapore, Singapore","institution_ids":["https://openalex.org/I165932596"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5137041740","display_name":"Sheng Wang","orcid":"https://orcid.org/0009-0007-1582-3316"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Sheng Wang","raw_affiliation_strings":["Alibaba Cloud, Singapore, Singapore"],"raw_orcid":"https://orcid.org/0009-0007-1582-3316","affiliations":[{"raw_affiliation_string":"Alibaba Cloud, Singapore, Singapore","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5111803125","display_name":"Feixue Zhou","orcid":null},"institutions":[{"id":"https://openalex.org/I45928872","display_name":"Alibaba Group (China)","ror":"https://ror.org/00k642b80","country_code":"CN","type":"company","lineage":["https://openalex.org/I45928872"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Fangyuan Zhou","raw_affiliation_strings":["Alibaba Cloud, Hangzhou, China"],"raw_orcid":"https://orcid.org/0009-0001-7742-670X","affiliations":[{"raw_affiliation_string":"Alibaba Cloud, Hangzhou, China","institution_ids":["https://openalex.org/I45928872"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5137043457","display_name":"Feifei Li","orcid":"https://orcid.org/0009-0003-0770-5775"},"institutions":[{"id":"https://openalex.org/I45928872","display_name":"Alibaba Group (China)","ror":"https://ror.org/00k642b80","country_code":"CN","type":"company","lineage":["https://openalex.org/I45928872"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Feifei Li","raw_affiliation_strings":["Alibaba Cloud, Hangzhou, China"],"raw_orcid":"https://orcid.org/0009-0003-0770-5775","affiliations":[{"raw_affiliation_string":"Alibaba Cloud, Hangzhou, China","institution_ids":["https://openalex.org/I45928872"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":7,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":0,"citation_normalized_percentile":{"value":0.86215594,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":"504","last_page":"517"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T12479","display_name":"Web Application Security Vulnerabilities","score":0.11180000007152557,"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/T12479","display_name":"Web Application Security Vulnerabilities","score":0.11180000007152557,"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.10559999942779541,"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.04490000009536743,"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/visibility","display_name":"Visibility","score":0.5479000210762024},{"id":"https://openalex.org/keywords/noise","display_name":"Noise (video)","score":0.24330000579357147},{"id":"https://openalex.org/keywords/field","display_name":"Field (mathematics)","score":0.22869999706745148}],"concepts":[{"id":"https://openalex.org/C123403432","wikidata":"https://www.wikidata.org/wiki/Q654068","display_name":"Visibility","level":2,"score":0.5479000210762024},{"id":"https://openalex.org/C62649853","wikidata":"https://www.wikidata.org/wiki/Q199687","display_name":"Remote sensing","level":1,"score":0.448199987411499},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.4047999978065491},{"id":"https://openalex.org/C31972630","wikidata":"https://www.wikidata.org/wiki/Q844240","display_name":"Computer vision","level":1,"score":0.3889999985694885},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.3416999876499176},{"id":"https://openalex.org/C127313418","wikidata":"https://www.wikidata.org/wiki/Q1069","display_name":"Geology","level":0,"score":0.29019999504089355},{"id":"https://openalex.org/C205649164","wikidata":"https://www.wikidata.org/wiki/Q1071","display_name":"Geography","level":0,"score":0.28929999470710754},{"id":"https://openalex.org/C99498987","wikidata":"https://www.wikidata.org/wiki/Q2210247","display_name":"Noise (video)","level":3,"score":0.24330000579357147},{"id":"https://openalex.org/C9652623","wikidata":"https://www.wikidata.org/wiki/Q190109","display_name":"Field (mathematics)","level":2,"score":0.22869999706745148},{"id":"https://openalex.org/C39432304","wikidata":"https://www.wikidata.org/wiki/Q188847","display_name":"Environmental science","level":0,"score":0.22679999470710754}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/3788853.3803091","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3788853.3803091","pdf_url":null,"source":null,"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Companion of the International Conference on Management of Data","raw_type":"proceedings-article"}],"best_oa_location":{"id":"doi:10.1145/3788853.3803091","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3788853.3803091","pdf_url":null,"source":null,"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Companion of the International Conference on Management of Data","raw_type":"proceedings-article"},"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":46,"referenced_works":["https://openalex.org/W1970165929","https://openalex.org/W1997519660","https://openalex.org/W2003751975","https://openalex.org/W2033114255","https://openalex.org/W2049314312","https://openalex.org/W2060328587","https://openalex.org/W2062666593","https://openalex.org/W2098129634","https://openalex.org/W2112474496","https://openalex.org/W2133089983","https://openalex.org/W2148291485","https://openalex.org/W2167541073","https://openalex.org/W2293299776","https://openalex.org/W2340417905","https://openalex.org/W2477316223","https://openalex.org/W2613206411","https://openalex.org/W2620722923","https://openalex.org/W2762664377","https://openalex.org/W2765714642","https://openalex.org/W2767894601","https://openalex.org/W2794933251","https://openalex.org/W2810768857","https://openalex.org/W2888240658","https://openalex.org/W2889252017","https://openalex.org/W2898125173","https://openalex.org/W2919933843","https://openalex.org/W2964232059","https://openalex.org/W2970632477","https://openalex.org/W2970918514","https://openalex.org/W2980178716","https://openalex.org/W3083560262","https://openalex.org/W3210990339","https://openalex.org/W4249285655","https://openalex.org/W4254666025","https://openalex.org/W4281777178","https://openalex.org/W4323530087","https://openalex.org/W4365786623","https://openalex.org/W4386768937","https://openalex.org/W4393183713","https://openalex.org/W4396571402","https://openalex.org/W4399460644","https://openalex.org/W4403536216","https://openalex.org/W4411260256","https://openalex.org/W4411265269","https://openalex.org/W7140756610","https://openalex.org/W7161564873"],"related_works":[],"abstract_inverted_index":{"Modern":[0],"Internet-scale":[1],"services":[2],"evolve,":[3],"yet":[4],"database":[5,72],"interactions":[6],"are":[7],"increasingly":[8],"obscured":[9],"by":[10],"languages,":[11],"frameworks,":[12],"and":[13,26,35,51,79,86,100,111,118,128,144,149],"abstraction":[14],"layers.":[15],"This":[16],"loss":[17],"of":[18,151],"visibility":[19,47],"weakens":[20],"the":[21],"link":[22],"between":[23,48],"code":[24,50],"changes":[25],"SQL":[27,53,84,95,152,156],"behavior,":[28],"leading":[29],"to":[30,82],"performance":[31],"regressions,":[32],"security":[33],"risks,":[34],"costly":[36],"diagnosis.":[37],"SQLens":[38,124],"is":[39],"a":[40,67,104],"practical":[41],"system":[42,90],"that":[43],"restores":[44],"auditable,":[45],"end-to-end":[46],"application":[49],"executed":[52],"in":[54,66,103,130],"large,":[55],"heterogeneous":[56],"codebases.":[57],"It":[58],"combines":[59],"static":[60],"program":[61],"analysis":[62],"with":[63,140],"LLM-guided":[64],"reasoning":[65],"closed-loop":[68],"workflow:":[69],"starting":[70],"from":[71],"emission":[73],"sites,":[74],"cooperative":[75],"agents":[76],"traverse":[77],"control":[78],"data":[80],"flows":[81],"reconstruct":[83],"construction":[85],"parameter":[87],"binding.":[88],"The":[89],"refines":[91],"these":[92],"mappings":[93],"using":[94],"logs":[96],"collected":[97],"over":[98],"time":[99],"stores":[101],"them":[102],"versioned":[105],"knowledge":[106],"layer":[107],"supporting":[108],"code-to-SQL":[109,131],"lookup":[110],"SQL-to-code":[112],"attribution.":[113],"Deployed":[114],"at":[115,158],"Alibaba":[116],"Group":[117],"evaluated":[119],"on":[120],"diverse":[121],"open-source":[122],"services,":[123],"achieves":[125],"high":[126],"precision":[127],"recall":[129],"reconstruction,":[132],"reduces":[133],"SQL-incident":[134],"resolution":[135],"time,":[136],"and,":[137],"when":[138],"integrated":[139],"continuous":[141,155],"integration":[142],"pipelines":[143],"runtime":[145],"observability,":[146],"supports":[147],"detection":[148],"mitigation":[150],"issues,":[153],"enabling":[154],"governance":[157],"industrial":[159],"scale.":[160]},"counts_by_year":[],"updated_date":"2026-06-11T09:08:48.828518","created_date":"2026-05-27T00:00:00"}