SUre, it will generate a query that gets you what you want - but will it use the right indices? Will use correct ordering for optimal results?
Generally (unless this has changed in more recent years) the answer is 'no'.