Towards Complex Text-to-SQL in Cross-Domain Database with Intermediate Representation. - Jiaqi Guo; Zecheng Zhan; Yan Gao 002; Yan Xiao; Jian-Guang Lou; Ting Liu 002; Dongmei Zhang 001 (ACL (1), 2019)

A Hybrid Semantic Parsing Approach for Tabular Data Analysis. - Yan Gao 002; Jian-Guang Lou; Dongmei Zhang 001 (CoRR, 2019)

"What Do You Mean by That?" A Parser-Independent Interactive Approach for Enhancing Text-to-SQL. - Yuntao Li; Bei Chen; Qian Liu; Yan Gao 002; Jian-Guang Lou; Yan Zhang 117; Dongmei Zhang 001 (EMNLP (1), 2020)

RECPARSER: A Recursive Semantic Parsing Framework for Text-to-SQL Task. - Yu Zeng; Yan Gao 002; Jiaqi Guo; Bei Chen; Qian Liu; Jian-Guang Lou; Fei Teng 001; Dongmei Zhang 001 (IJCAI, 2020)

Compositional Generalization by Learning Analytical Expressions. - Qian Liu; Shengnan An; Jian-Guang Lou; Bei Chen; Zeqi Lin; Yan Gao 002; Bin Zhou; Nanning Zheng 001; Dongmei Zhang 001 (NeurIPS, 2020)

Translating Headers of Tabular Data: A Pilot Study of Schema Translation. - Kunrui Zhu; Yan Gao 002; Jiaqi Guo; Jian-Guang Lou (EMNLP (1), 2021)

Keep the Structure: A Latent Shift-Reduce Parser for Semantic Parsing. - Yuntao Li; Bei Chen; Qian Liu; Yan Gao 002; Jian-Guang Lou; Yan Zhang 117; Dongmei Zhang 001 (IJCAI, 2021)

HiTab: A Hierarchical Table Dataset for Question Answering and Natural Language Generation. - Zhoujun Cheng; Haoyu Dong 001; Zhiruo Wang; Ran Jia; Jiaqi Guo; Yan Gao 002; Shi Han; Jian-Guang Lou; Dongmei Zhang 001 (ACL (1), 2022)

Towards Robustness of Text-to-SQL Models Against Natural and Realistic Adversarial Table Perturbation. - Xinyu Pi; Bing Wang; Yan Gao 002; Jiaqi Guo; Zhoujun Li 001; Jian-Guang Lou (ACL (1), 2022)

Towards Knowledge-Intensive Text-to-SQL Semantic Parsing with Formulaic Knowledge. - Longxu Dou; Yan Gao 002; Xuqi Liu; Mingyang Pan; Dingzirui Wang; Wanxiang Che; Dechen Zhan; Min-Yen Kan; Jian-Guang Lou (EMNLP, 2022)

Reasoning Like Program Executors. - Xinyu Pi; Qian Liu; Bei Chen; Morteza Ziyadi; Zeqi Lin; Qiang Fu; Yan Gao 002; Jian-Guang Lou; Weizhu Chen (EMNLP, 2022)

LogiGAN: Learning Logical Reasoning via Adversarial Pre-training. - Xinyu Pi; Wanjun Zhong; Yan Gao 002; Nan Duan; Jian-Guang Lou (NeurIPS, 2022)

UniSAr: A Unified Structure-Aware Autoregressive Language Model for Text-to-SQL. - Longxu Dou; Yan Gao 002; Mingyang Pan; Dingzirui Wang; Jian-Guang Lou; Wanxiang Che; Dechen Zhan (CoRR, 2022)

Know What I don't Know: Handling Ambiguous and Unanswerable Questions for Text-to-SQL. - Bing Wang; Yan Gao 002; Zhoujun Li 001; Jian-Guang Lou (CoRR, 2022)

How to manage a task-oriented virtual assistant software project: an experience report. - Shuyue Li; Jiaqi Guo; Yan Gao 002; Jian-Guang Lou; Dejian Yang; Yan Xiao; Yadong Zhou; Ting Liu 002 (Frontiers Inf. Technol. Electron. Eng., 2022)

MultiSpider: Towards Benchmarking Multilingual Text-to-SQL Semantic Parsing. - Longxu Dou; Yan Gao 002; Mingyang Pan; Dingzirui Wang; Wanxiang Che; Dechen Zhan; Jian-Guang Lou (AAAI, 2023)

Uncovering and Categorizing Social Biases in Text-to-SQL. - Yan Liu 002; Yan Gao 002; Zhe Su; Xiaokang Chen; Elliott Ash; Jian-Guang Lou (ACL (1), 2023)

Know What I don't Know: Handling Ambiguous and Unknown Questions for Text-to-SQL. - Bing Wang; Yan Gao 002; Zhoujun Li 001; Jian-Guang Lou (ACL (Findings), 2023)

TACR: A Table Alignment-based Cell Selection Method for HybridQA. - Jian Wu 037; Yicheng Xu; Yan Gao 002; Jian-Guang Lou; Börje Karlsson 001; Manabu Okumura (ACL (Findings), 2023)

CRT-QA: A Dataset of Complex Reasoning Question Answering over Tabular Data. - Zhehao Zhang 001; Xitao Li; Yan Gao 002; Jian-Guang Lou (EMNLP, 2023)

Uncovering and Quantifying Social Biases in Code Generation. - Yan Liu 002; Xiaokang Chen; Yan Gao 002; Zhe Su; Fengji Zhang; Daoguang Zan; Jian-Guang Lou; Pin-Yu Chen; Tsung-Yi Ho (NeurIPS, 2023)

TACR: A Table-alignment-based Cell-selection and Reasoning Model for Hybrid Question-Answering. - Jian Wu 037; Yicheng Xu; Yan Gao 002; Jian-Guang Lou; Börje F. Karlsson; Manabu Okumura (CoRR, 2023)

UniSAr: a unified structure-aware autoregressive language model for text-to-SQL semantic parsing. - Longxu Dou; Yan Gao 002; Mingyang Pan; Dingzirui Wang; Wanxiang Che; Jian-Guang Lou; Dechen Zhan (Int. J. Mach. Learn. Cybern., 2023)

Text2Analysis: A Benchmark of Table Question Answering with Advanced Data Analysis and Unclear Queries. - Xinyi He; Mengyu Zhou; Xinrun Xu; Xiaojun Ma; Rui Ding 001; Lun Du; Yan Gao 002; Ran Jia; Xu Chen 022; Shi Han; Zejian Yuan; Dongmei Zhang 001 (AAAI, 2024)

E⁵: Zero-shot Hierarchical Table Analysis using Augmented LLMs via Explain, Extract, Execute, Exhibit and Extrapolate. - Zhehao Zhang 001; Yan Gao 002; Jian-Guang Lou (NAACL-HLT, 2024)

NL2Formula: Generating Spreadsheet Formulas from Natural Language Queries. - Wei Zhao 040; Zhitao Hou; Siyuan Wu 001; Yan Gao 002; Haoyu Dong 001; Yao Wan 001; Hongyu Zhang 002; Yulei Sui; Haidong Zhang (CoRR, 2024)