{"id":"W3008396432","doi":"10.1145/3318464.3380602","title":"Facilitating SQL Query Composition and Analysis","year":2020,"lang":"en","type":"preprint","venue":"","topic":"Advanced Database Systems and Queries","field":"Computer Science","cited_by":2,"is_retracted":false,"has_abstract":true,"ca_institutions":"University of British Columbia","funders":"","keywords":"Computer science; Spatial query; Sargable; Query by Example; SQL; Query optimization; Web query classification; Class (philosophy); Query language; Query expansion; Web search query; Workload; Data mining; Database; Information retrieval; Artificial intelligence; Search engine; Operating system","routes":{"ca_aff":true,"ca_fund":false,"ca_venue":false,"about_ca":false,"invisible_to_affiliation_only":false},"retraction":null,"screen":null,"direct_labels":[],"prediction":{"model_version":"metacan-v3-hybrid-931329e0061c","candidate_categories":[],"consensus_categories":[],"category_scores_codex":[0.008883543,0.002884068,0.002101387,0.002383513,0.001517577,0.005358211,0.003039644,0.001136909,0.009341052],"category_scores_gemma":[0.0371961,0.001683505,0.001958361,0.001865348,0.001523832,0.006894818,0.004485971,0.003767332,0.004693215],"about_ca_system_candidate":false,"about_ca_system_consensus":false,"about_ca_system_score_codex":0.001786661,"about_ca_system_score_gemma":0.003792524,"about_ca_topic_candidate":false,"about_ca_topic_consensus":false,"about_ca_topic_score_codex":0.005056763,"about_ca_topic_score_gemma":0.006022865,"domain_scores_codex":[0.9843701,0.004105128,0.001421454,0.002955079,0.005980781,0.001167564],"domain_scores_gemma":[0.9710029,0.01715192,0.00110722,0.006853173,0.003236218,0.0006485639],"domain_codex":null,"domain_gemma":null,"domain_candidate":null,"domain_consensus":null,"study_design_codex":"design_other","study_design_gemma":"simulation_or_modeling","study_design_scores_codex":[0.001861348,0.001462597,0.02204341,0.0008611984,0.0003482178,0.0008178466,0.001953123,0.05808022,0.1241727,0.0380923,0.02763311,0.722674],"study_design_scores_gemma":[0.0001221949,0.0001875283,0.003841256,0.0000825473,0.0001111565,0.0003822312,0.0005912473,0.8254228,0.09636519,0.04286282,0.02990519,0.0001258883],"study_design_candidate":"simulation_or_modeling","study_design_consensus":null,"genre_codex":"methods","genre_gemma":"empirical","genre_scores_codex":[0.04049616,0.0003003686,0.8671854,0.0006472561,0.0001003095,0.0008405564,0.000689705,0.08495108,0.00478922],"genre_scores_gemma":[0.3980431,0.0003467929,0.5815951,0.0005830858,0.0001625914,0.000469401,0.002991443,0.01078869,0.005019719],"genre_candidate":"empirical","genre_consensus":null,"teacher_disagreement_score":0.009341052,"threshold_uncertainty_score":0.04698128,"prediction_status":"machine_predicted_unvalidated"},"machine_scores":{"provisional":true,"baseline":true,"maturity_gate_passed":false,"score_opus":0.02791884469615542,"score_gpt":0.2768290117648426,"score_spread":0.2489101670686872,"validation_status":"score_only:v0-immature-baseline","note":"Baseline scores from an immature model (maturity gate not passed). Scores rank; they never assert a category."}}