{"id":"https://openalex.org/W4281778410","doi":"https://doi.org/10.48550/arxiv.2205.12422","title":"Non-Programmers Can Label Programs Indirectly via Active Examples: A Case Study with Text-to-SQL","display_name":"Non-Programmers Can Label Programs Indirectly via Active Examples: A Case Study with Text-to-SQL","publication_year":2022,"publication_date":"2022-05-25","ids":{"openalex":"https://openalex.org/W4281778410","doi":"https://doi.org/10.48550/arxiv.2205.12422"},"language":"en","primary_location":{"id":"pmh:oai:arXiv.org:2205.12422","is_oa":true,"landing_page_url":"http://arxiv.org/abs/2205.12422","pdf_url":"https://arxiv.org/pdf/2205.12422","source":{"id":"https://openalex.org/S4306400194","display_name":"arXiv (Cornell University)","issn_l":"2331-8422","issn":["2331-8422"],"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":null,"raw_type":"text"},"type":"preprint","indexed_in":["arxiv","datacite"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"https://arxiv.org/pdf/2205.12422","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5046116522","display_name":"Ruiqi Zhong","orcid":"https://orcid.org/0000-0002-3153-4027"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Zhong, Ruiqi","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5052858739","display_name":"Charlie Snell","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Snell, Charlie","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5004921249","display_name":"Dan Klein","orcid":"https://orcid.org/0000-0002-8881-1902"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Klein, Dan","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"last","author":{"id":"https://openalex.org/A5052467896","display_name":"Jason Eisner","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Eisner, Jason","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":true,"cited_by_count":3,"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/T10260","display_name":"Software Engineering Research","score":0.9988999962806702,"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/T10260","display_name":"Software Engineering Research","score":0.9988999962806702,"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/T10028","display_name":"Topic Modeling","score":0.9829000234603882,"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/T10181","display_name":"Natural Language Processing Techniques","score":0.9674999713897705,"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.9014946222305298},{"id":"https://openalex.org/keywords/parsing","display_name":"Parsing","score":0.6113448143005371},{"id":"https://openalex.org/keywords/annotation","display_name":"Annotation","score":0.5615278482437134},{"id":"https://openalex.org/keywords/natural-language-processing","display_name":"Natural language processing","score":0.5566667318344116},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.5496149063110352},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.5264179110527039},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.5230991840362549},{"id":"https://openalex.org/keywords/utterance","display_name":"Utterance","score":0.5174573063850403},{"id":"https://openalex.org/keywords/simple","display_name":"Simple (philosophy)","score":0.4151079058647156}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.9014946222305298},{"id":"https://openalex.org/C186644900","wikidata":"https://www.wikidata.org/wiki/Q194152","display_name":"Parsing","level":2,"score":0.6113448143005371},{"id":"https://openalex.org/C2776321320","wikidata":"https://www.wikidata.org/wiki/Q857525","display_name":"Annotation","level":2,"score":0.5615278482437134},{"id":"https://openalex.org/C204321447","wikidata":"https://www.wikidata.org/wiki/Q30642","display_name":"Natural language processing","level":1,"score":0.5566667318344116},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.5496149063110352},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.5264179110527039},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.5230991840362549},{"id":"https://openalex.org/C2775852435","wikidata":"https://www.wikidata.org/wiki/Q258403","display_name":"Utterance","level":2,"score":0.5174573063850403},{"id":"https://openalex.org/C2780586882","wikidata":"https://www.wikidata.org/wiki/Q7520643","display_name":"Simple (philosophy)","level":2,"score":0.4151079058647156},{"id":"https://openalex.org/C138885662","wikidata":"https://www.wikidata.org/wiki/Q5891","display_name":"Philosophy","level":0,"score":0.0},{"id":"https://openalex.org/C111472728","wikidata":"https://www.wikidata.org/wiki/Q9471","display_name":"Epistemology","level":1,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"pmh:oai:arXiv.org:2205.12422","is_oa":true,"landing_page_url":"http://arxiv.org/abs/2205.12422","pdf_url":"https://arxiv.org/pdf/2205.12422","source":{"id":"https://openalex.org/S4306400194","display_name":"arXiv (Cornell University)","issn_l":"2331-8422","issn":["2331-8422"],"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":null,"raw_type":"text"},{"id":"doi:10.48550/arxiv.2205.12422","is_oa":true,"landing_page_url":"https://doi.org/10.48550/arxiv.2205.12422","pdf_url":null,"source":{"id":"https://openalex.org/S4306400194","display_name":"arXiv (Cornell University)","issn_l":"2331-8422","issn":["2331-8422"],"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":"pmh:oai:arXiv.org:2205.12422","is_oa":true,"landing_page_url":"http://arxiv.org/abs/2205.12422","pdf_url":"https://arxiv.org/pdf/2205.12422","source":{"id":"https://openalex.org/S4306400194","display_name":"arXiv (Cornell University)","issn_l":"2331-8422","issn":["2331-8422"],"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":null,"raw_type":"text"},"sustainable_development_goals":[{"display_name":"Quality Education","id":"https://metadata.un.org/sdg/4","score":0.7699999809265137}],"awards":[{"id":"https://openalex.org/G3664711276","display_name":"Collaborative Research: Transferable, Hierarchical, Expressive, Optimal, Robust, Interpretable Networks","funder_award_id":"2031985","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"}],"funders":[{"id":"https://openalex.org/F4320306076","display_name":"National Science Foundation","ror":"https://ror.org/021nxhr62"}],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":0,"referenced_works":[],"related_works":["https://openalex.org/W2529301793","https://openalex.org/W2384121599","https://openalex.org/W2038083449","https://openalex.org/W2361861616","https://openalex.org/W3177678247","https://openalex.org/W1999617572","https://openalex.org/W2944572343","https://openalex.org/W2263699433","https://openalex.org/W3046984657","https://openalex.org/W2053943328"],"abstract_inverted_index":{"Can":[0],"non-programmers":[1,20,76,108],"annotate":[2],"natural":[3],"language":[4],"utterances":[5],"with":[6],"complex":[7],"programs":[8,24,66],"that":[9],"represent":[10],"their":[11],"meaning?":[12],"We":[13],"introduce":[14],"APEL,":[15],"a":[16,27,59,101,115],"framework":[17],"in":[18,136],"which":[19,63,88],"select":[21,44],"among":[22],"candidate":[23,38,65],"generated":[25],"by":[26,46],"seed":[28],"semantic":[29],"parser":[30],"(e.g.,":[31],"Codex).":[32],"Since":[33],"they":[34],"cannot":[35],"understand":[36],"the":[37,48,64,75,80,98,121,126,137],"programs,":[39],"we":[40,105],"ask":[41],"them":[42],"to":[43,68,78,86,96,109,112],"indirectly":[45],"examining":[47],"programs'":[49],"input-ouput":[50],"examples.":[51],"For":[52],"each":[53],"utterance,":[54],"APEL":[55,111],"actively":[56],"searches":[57],"for":[58],"simple":[60],"input":[61],"on":[62],"tend":[67],"produce":[69],"different":[70],"outputs.":[71],"It":[72],"then":[73],"asks":[74],"only":[77],"choose":[79],"appropriate":[81],"output,":[82],"thus":[83],"allowing":[84],"us":[85],"infer":[87],"program":[89],"is":[90],"correct":[91],"and":[92,131],"could":[93],"be":[94],"used":[95],"fine-tune":[97],"parser.":[99],"As":[100],"first":[102],"case":[103],"study,":[104],"recruited":[106],"human":[107],"use":[110],"re-annotate":[113],"SPIDER,":[114],"text-to-SQL":[116],"dataset.":[117],"Our":[118],"approach":[119],"achieved":[120],"same":[122],"annotation":[123],"accuracy":[124],"as":[125],"original":[127,138],"expert":[128],"annotators":[129],"(75%)":[130],"exposed":[132],"many":[133],"subtle":[134],"errors":[135],"annotations.":[139]},"counts_by_year":[{"year":2023,"cited_by_count":3}],"updated_date":"2026-08-11T07:18:39.950985","created_date":"2022-06-13T00:00:00"}