Improving SQL Query Readability Through Refactoring

Refactoring is a process of transforming software code to improve its quality while preserving its functionality. The goal of this research is to develop methods for refactoring SQL queries. Changing the text of queries does not affect the schema of the existing database. The goal of the refactoring methods themselves is to make the query easier to understand and improve its readability. Readability assessments of query texts are based on the Automated Readability Index. Methods aimed at simplifying the structure of queries have shown improvements in the readability index of queries up to 20%.