I've done some digging and it's a pebkac issue, the below property resolves the issue.
logging.*level*.org.hibernate.SQL=DEBUG
Thanks for all your assistance.