Extensions
Supported Operations
Below is a list of supported operations.  
#### `CREATE TABLE` {#docs:extensions:sqlite::create-table}  
```sql
CREATE TABLE sqlite_db.tbl (id INTEGER, name VARCHAR);
```  
#### `INSERT INTO` {#docs:extensions:sqlite::insert-into}  
```sql
INSERT INTO sqlite_db.tbl VALUES (42, 'DuckDB');
```  
#### `SELECT` {#docs:extensions:sqlite::select}  
```sql
SELECT * FROM sqlite_db.tbl;
```  
| id |  name  |
|---:|--------|
| 42 | DuckDB |  
#### `COPY` {#docs:extensions:sqlite::copy}  
```sql
COPY sqlite_db.tbl TO 'data.parquet';
COPY sqlite_db.tbl FROM 'data.parquet';
```  
#### `UPDATE` {#docs:extensions:sqlite::update}  
```sql
UPDATE sqlite_db.tbl SET name = 'Woohoo' WHERE id = 42;
```  
#### `DELETE` {#docs:extensions:sqlite::delete}  
```sql
DELETE FROM sqlite_db.tbl WHERE id = 42;
```  
#### `ALTER TABLE` {#docs:extensions:sqlite::alter-table}  
```sql
ALTER TABLE sqlite_db.tbl ADD COLUMN k INTEGER;
```  
#### `DROP TABLE` {#docs:extensions:sqlite::drop-table}  
```sql
DROP TABLE sqlite_db.tbl;
```  
#### `CREATE VIEW` {#docs:extensions:sqlite::create-view}  
```sql
CREATE VIEW sqlite_db.v1 AS SELECT 42;
```  
#### Transactions {#docs:extensions:sqlite::transactions}  
```sql
CREATE TABLE sqlite_db.tmp (i INTEGER);
```  
```sql
BEGIN;
INSERT INTO sqlite_db.tmp VALUES (42);
SELECT * FROM sqlite_db.tmp;
```  
| i  |
|---:|
| 42 |  
```sql
ROLLBACK;
SELECT * FROM sqlite_db.tmp;
```  
| i |
|--:|
|   |  
> **Deprecated.  ** The old `sqlite_attach` function is deprecated. It is recommended to switch over to the new [`ATTACH` syntax](#docs:sql:statements:attach).