query

Execute an RQL query

Changed on

Execute SQL-like queries against documents using ReasonDB Query Language (RQL).

Supports:

  • WHERE clauses for filtering by tags, author, metadata
  • SEARCH clause for BM25 full-text search (fast keyword matching)
  • REASON clause for LLM semantic search (intelligent answer extraction)
  • GROUP BY and aggregate functions (COUNT, SUM, AVG)
  • EXPLAIN to view query execution plans
post/v1/query

Request

Request body

querystring required

RQL query string

timeout_msinteger

Optional timeout in milliseconds

Example request

{
  "query": "SELECT * FROM legal WHERE author = 'Alice' LIMIT 10"
}

Response

Query executed successfully

total_countinteger

Total count before pagination

execution_time_msinteger

Execution time in milliseconds

Changes

    • breaking

      the response's property type changed from object to no type for status

    • warning

      removed the optional property / from the response with the status

    • warning

      removed the optional property / from the response with the status

    • warning

      removed the optional property / from the response with the status

    • info

      added to the response property allOf list for the response status

    • warning

      removed the optional property // from the response with the status

    • info

      added the optional property // to the response with the status