Whats the advantage and disadvantage of Sqlexec in peoplecode?

Sqlexec allows us to write SQl statements in Peoplecode.Through SQLexec we can insert,update and delete.It returns one row of data.

Disadvantage:

Even though select returns multiple rows Sqlexec returns one row.