# Orange ORM - The ultimate ORM for Node and Typescript.

> Fetch rows directly in the browser. Developer friendly, concise with powerful filtering.

## Table of Contents

### GETTING STARTED

- [Installation](/installation.md)
- [Connecting](/connecting.md)
- [Mapping tables](/mapping-tables.md)
- [Data types](/data-types.md)
- [Enums](/enums.md)
- [Example](/example.md)

### CRUD

- [Inserting rows](/inserting-rows.md)
- [Fetching rows](/fetching-rows.md)
- [Updating rows](/updating-rows.md)
- [Upserting rows](/upserting-rows.md)
- [Deleting rows](/deleting-rows.md)

### FILTERS

- [Basic filters](/basic-filters.md)
- [Relation filters](/relation-filters.md)
- [And, or, not, exists](/logical-filters.md)
- [Any, all, none](/any-filters.md)
- [Fetching strategies](/fetching-strategies.md)

### CONSTRAINTS

- [Default values](/default-values.md)
- [Validation](/validation.md)
- [Composite keys](/composite-keys.md)
- [Column discriminators](/column-discriminators.md)
- [Formula discriminators](/formula-discriminators.md)

### ADVANCED FEATURES

- [Transactions](/transactions.md)
- [Raw sql queries](/raw-sql-queries.md)
- [Aggregate functions](/aggregates.md)
- [Excluding sensitive data](/excluding-sensitive-data.md)

### RUNTIME

- [Logging](/logging.md)
- [In the browser](/in-the-browser.md)
- [SQLite user-defined functions](/sqlite-user-defined-functions.md)

### PROJECT

- [What it is not](/what-it-is-not.md)