# collections query

## Synopsis

```shell
omics publisher collections query [QUERY]
  --collection=COLLECTION_ID
  [--decimal-as=FORMAT]
  [--no-auth]
```

## Description

Query data from a collection using SQL syntax. The query is executed against the collection's data and results are returned in the specified format.

## Examples

Query all data from a collection.

```shell
omics publisher collections query 'SELECT * FROM table LIMIT 10' --collection my-collection
```

Query with custom decimal formatting.

```shell
omics publisher collections query 'SELECT * FROM table WHERE value > 100' --collection my-collection --decimal-as number
```

## Positional Arguments

### `QUERY`

The SQL query to execute against the collection's data.

## Flags

### `--collection`=`COLLECTION_ID`

The ID or slug name of the collection to query.

### `--decimal-as`=`FORMAT`

Specify how decimal values should be formatted in the output. Defaults to `string`.

Valid formats: `string`, `number`

### `--no-auth`

Execute the query without authentication. Only works for publicly accessible collections.