Load data from a csv file without using COPY

In order to test a real life scenario (and use it for benchmarking) I want to load large number of data from csv files.
 
The requirement is that the load should happen like an application writing to the database ( that is, no COPY command).

Is there a tool which can do the job.  Basically parse the csv file and insert it to the database row by row.

thanks