"Is there a way preferbly in properties file to instruct spring boot to use it?"

Short answer is NO.

Long answer you need to do it manually for each query you execute.

Also there is no universal way to do it. Solution will be different for different DB.