# SQL Queries

## Overview

On processor initialisation, a set of queries are auto generated which are used to bind Rest API endpoints.

## SELECT

The following queries are generated:

1. Select data using pagination either with or without an `ingestTime` date range.  
2. Ability to export the table either by `CSV` or `Parquet` format.
3. Query to delete rows from the table between an `ingestTime` date range. 

### Example

The below example exports the quotes table within the `nasdaq_quotes` schema to a local parquet file.

Read the Data API query [page](https://docs.fractalworks.io/joule/developer-guides/api-endpoints/data-access-api/query) more information on how to access the captured data.

```javascript
const response = await fetch('/joule/query/nasdaq_quotes/quotes}', {
    method: 'GET',
    headers: {},
});
const data = await response.json();
```