In other words, just like when I run an SQL query myself or ask a team member to do it.

The correct usage here is of course not to just run a natural language query and blindly trust the results. Sanity checking both the query and results is essential.

I still find LLMs incredibly useful in exposing new SQL functionality to me or refactoring larger existing queries to a very different approach (as SQL is unfortunately does not allow defining query components in a modular way that would let me avoid that).