Hi, I can help you in logging the hibernate queries. if you are using spring boot it is very easy to log queries based on HQL. Kindly go through my profile and if you find it suitable please reach out to me.
which technologies are you using?
if you use spring data jpa check your @repository you can write queries there
or add a configuration in your .properties
Thanks