placeholders becomes total mess if you have more then 30 of them and have to calculate order

I use MySQL but don't really need to worry about these things because I also use DBIx::Class. If you are worrying about your inserts being slow because of it (though I doubt they will), use the same thing DBIx::Class uses to generate SQL: SQL::Abstract.