Add SQL Format Option

[hendisantika]

Add SQL Format Option so that sql log can look feels good.

Like on Spring Boot properties
spring.jpa.properties.hibernate.format_sql=true

Name:dataSource, Connection:7, Time:20, Success:True
Type:Prepared, Batch:False, QuerySize:1, BatchSize:0
Query:["select u1_0.id,u1_0.active,u1_0.confirmation_token,u1_0.email,u1_0.fullname,u1_0.password,u1_0.phone,u1_0.username,u1_1.station_id from user_account u1_0 left join users_station u1_1 on u1_0.id=u1_1.user_id where u1_0.email=?"]
Params:[(user001@yopmail.com)]

It would be better like this:

Name:dataSource, Connection:7, Time:20, Success:True
Type:Prepared, Batch:False, QuerySize:1, BatchSize:0
Query:["
SELECT u1_0.id,
       u1_0.active,
       u1_0.confirmation_token,
       u1_0.email,
       u1_0.fullname,
       u1_0.password,
       u1_0.phone,
       u1_0.username,
       u1_1.station_id
FROM user_account u1_0
         LEFT JOIN users_station u1_1 ON u1_0.id = u1_1.user_id
WHERE u1_0.email=?;
"]
Params:[(user001@yopmail.com)]

Thanks

[ttddyy]

Yes, it is already possible to format output queries.

The Spring Boot property, spring.jpa.properties.hibernate.format_sql delegates the property to Hibernate, and ultimately, Hibernate uses Formatter to format the queries.

Please see the "5.1. Query Logging Listener" section in the documentation. When you scroll down a bit, there is a code snippet that demonstrates the hibernate formatter usage.

Also, the datasource-proxy-examples project has an example code using Hibernate formatter:

• https://github.com/ttddyy/datasource-proxy-examples/blob/master/hibernate-example/src/main/java/net/ttddyy/dsproxy/example/Application.java#L52-L60
• https://github.com/ttddyy/datasource-proxy-examples/blob/master/hibernate-example/src/main/java/net/ttddyy/dsproxy/example/Application.java#L133-L137