SQL
Order Preservation
For many operations, DuckDB preserves the insertion order of rows, similarly to data frame libraries such as Pandas.
The following operations and components respect insertion order:  
* [The CSV reader](#docs:data:csv:overview::order-preservation)  
Preservation of insertion order is controlled by the  `preserve_insertion_order` [configuration option](#docs:configuration:overview).
This setting is `true` by default, indicating that the order should be preserved.
To change this setting, use:  
```sql
SET preserve_insertion_order = false;
```