TeslaCN commented on code in PR #19784: URL: https://github.com/apache/shardingsphere/pull/19784#discussion_r935189230
########## docs/blog/content/material/2022_03_09_SQL_Parse_Format_Function_A _Technical_Deep_Dive_by_Apache_ShardingSphere.en.md: ########## @@ -0,0 +1,282 @@ ++++ +title = "SQL Parse Format Function — A Technical Deep Dive by Apache ShardingSphere +" +chapter = true ++++ + +Complicted SQL statements are some of the most common problems that data scientists and engineers encounter. For example, can you comprehend at first glance the complex SQL statement below? + +``` +select a.order_id,a.status,sum(b.money) as money from t_order a inner join (select c.order_id as order_id, c.number * d.price as money from t_order_detail c inner join t_order_price d on c.s_id = d.s_id) b on a.order_id = b.order_id where b.money > 100 group by a.order_id +``` + +How about formatting it? Is it easier to understand the formatted formatted version below? + +``` Review Comment: ```suggestion ```sql ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
