# redivis$query

### **redivis$**<mark style="color:purple;">**query**</mark>**(query)** → [Query](https://docs.redivis.com/api/client-libraries/redivis-r/reference/query)

Execute a SQL query across any tables on Redivis.

### **Parameters:**

**`query` :&#x20;*****str*** \
The SQL query to execute. Must follow the [Redivis SQL query syntax](https://docs.redivis.com/reference/projects/transform-nodes/raw-sql).

### **Returns:**

[**Query**](https://docs.redivis.com/api/client-libraries/redivis-r/reference/query)

### Examples

```r
# The query can reference any table on Redivis 
query = redivis$query("
    SELECT * 
    FROM demo.iris_species.iris 
    WHERE SepalLengthCm > 5
")
query$to_tibble()
# 	Id	SepalLengthCm	SepalWidthCm	PetalLengthCm	PetalWidthCm	Species
# 0	33	5.2	        4.1	        1.5	        0.1	        Iris-setosa
# ...
```