UniParseAl
Aun Mohammad Kidwail, Mohd. Amaan, Shariq Shareef, Huda Khan · 2025
UniParseAl is an advanced parsing library designed to enhance SQL query processing. Built on the foundation of an open-source SQL parser, UniParseAl introduces significant enhancements, including query normalization, detailed component extraction, and comprehensive updating capabilities. The normalizer standardizes queries into a consistent format, improving readability and manageability. Extractors identify and categorize query components such as columns, tables, conditions, formatting parameters, functions, and subqueries, offering detailed insights for analysis and optimization. The updaters enable flexible modifications of these components, allowing for extensive query restructuring. UniParseAl handles both single and bulk queries of mixed complexity, generating structured data frames as output. Future developments include NoSQL support, virtual table introduction for efficient bulk query processing, and natural language processing (NLP) integration for intuitive query manipulation. This paper presents the architecture, features, and performance of UniParseAl, highlighting its contributions to enhancing query handling in both SQL and NoSQL environments.