Can not drop table when using CLI to execute SQL files

Now dropping table requires to confirm with users input which make it impossible to run with SQL files.

The issue is about the CLI's interactive confirmation prompt blocking SQL file execution for DROP TABLE. Look for the CLI command handling code, likely in a source file related to SQL execution or command-line interface. Find where the confirmation prompt is triggered for destructive operations and see if there's a flag or mode to bypass it for non-interactive use. Check if there are existing tests for CLI SQL file execution to understand the expected behavior.

Written by the indexing model from the issue text.