Query Database smart service to connect to an external database.

I'm using the Query Database smart service to connect to an external database. I've set up the connected system correctly, but when I run the process model, it doesn't work as expected and doesn't show any errors. However, when I use the Execute Stored Procedure smart service with the same connected system, it works fine. Can you help me understand why the Query Database smart service isn't working?