Is it possible/useful to extract SQL queries into a “config file”?

I'm wondering if it is possible to extract SQL queries into a config file so they can be changed without requiring recompiling and redeploying the app. Is something like this possible, and if it is possible, is it a good idea?