It depends on the application. The reason is not because of the construction of the SQL, but because of using one query per command. That can be damn slow: if you try to add a lot of data (ten thousands of records) into the database, using such a module can take 15 minutes where a plain native import takes 10 seconds. That is 2 orders of magnitude slower. Plain DBI is somewhere between these two extremes.

For single record access, it'll hardly make a difference, it's just a matter of milliseconds.