> For the complete documentation index, see [llms.txt](https://docs.fractalworks.io/joule/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.fractalworks.io/joule/components/processors/event-tap/sql-queries.md).

# 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](/joule/developer-guides/api-endpoints/data-access-api/query.md) 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();
```