Support TRUNCATE DATABASE operation

Why it matters

This feature introduces the TRUNCATE DATABASE command to allow users to efficiently remove all data from a database at once, simplifying cleanup and maintenance tasks without dropping the database itself.

How to use it

Users can perform a TRUNCATE DATABASE <database_name> command to quickly delete all data inside the specified database while keeping its schema intact.