add option to truncate tables with an identity/auto-incr reset

[s-mang]

it would be nice to be able to reset the auto-increment counter when truncating tables.

This solution is backwards-compatible & has a test :cake: Let me know if you'd like anything changed

Cheers ~

[jmoiron]

This looks great! Thanks for the PR :v: