Text Input

{% text_input
    id="search"
    title="Search"
    placeholder="Enter search term..."
/%}

{% table
    data="demo.daily_orders"
    where="category ilike '%{{search}}%'"
/%}

{% text_input
    id="search"
    title="Search"
    placeholder="Enter search term..."
/%}

{% table
    data="demo.daily_orders"
    where="category ilike '%{{search}}%'"
/%}

{% text_input
    id="search"
    title="Search"
    placeholder="Enter search term..."
/%}

```sql search_results
select * from demo.daily_orders
[[where category ilike '%{{search}}%']]
```

{% table data="search_results" /%}

{% text_input id="search_term" /%}

```sql filtered_products
select * from products
where product_name ILIKE '%{{search_term}}%'
```