I just downloaded the Tie::DBI module to take a look before commenting, and it looks pretty cool.
It probably works fine, although Lincoln does mention a fairly significant speed penalty over plain DBI.

Personally I'd use the regular DBI syntax, mostly for maintainability, and because it clearly exposes what SQL statements are going to get executed - if you ever need to find out why a certain part of your app is performing slowly then this is really a necessity. Another thing that I don't think it does is JOIN queries, and that's another thing that you're likely going to need if you go beyond a very simple app.

Just my $0.02, of course :-)

Michael