Creates a new Query instance with a SQLite database connection. Automatically enables WAL mode for better concurrency.
Optionalfilename: stringDisposes of the database connection by closing it. This method is called automatically when using the 'using' keyword.
Creates a table definition builder for creating or modifying table schemas.
Creates a DELETE query builder for the specified table.
Creates a SELECT query builder for the specified table.
Creates an INSERT query builder for the specified table.
Executes multiple operations within a database transaction. All operations will be rolled back if any operation fails.
Creates an UPDATE query builder for the specified table.
Main query builder class that provides a fluent interface for constructing and executing SQL queries. Automatically manages database connections and provides methods for SELECT, INSERT, UPDATE, DELETE, and DDL operations.