What is the difference in using SQL directly and calling SQL from Peoplecode in Application Engine?

If you use SQL directly then it will go to database directly to fetch rows of data. But if u write SQL'S in peoplecode, den the trip will be from application server to database because peoplecode resides in app server.