> For the complete documentation index, see [llms.txt](https://clear.gitbook.io/project/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://clear.gitbook.io/project/querying/low-level-sql/select-clause.md).

# Select Clause

## The Select query

Clear allows you to build Select query  

## String substitution in SELECT

```ruby
Model.query.select( 
  Clear::SQL.raw("CASE WHEN x=:x THEN 1 ELSE 0 END as check", x: "blabla") 
)
```