collections query

Query data from a collection

Synopsis

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.

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

Query with custom decimal formatting.

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.