Osquery uses basic SQL commands to leverage a relational data-model to describe a device.

osquery

Hi guys,
When I tried to run
```EXISTS(SELECT size from file where path = '/tmp/et.txt')```
I get this error : "Error: near "EXISTS": syntax error"
Maybe do you have a  different solution instead of "EXISTS" ?

Osquery uses SQLite as the underlying engine. So whatever works there will work. 

What is exists supposed to do?

<https://osquery.slack.com/archives/C08V7KTJB/p1598361344038400?thread_ts=1598361123.037000&amp;cid=C08V7KTJB>

Likewise you could write:
```SELECT 'true' AS is_present FROM file WHERE path = '/tmp/et.txt'```

If you wanted to return a boolean row both when the file was present/missing you could employ `CASE` logic as follows:

```SELECT CASE WHEN (SELECT 1 FROM file WHERE path = '/tmp/et.txt') THEN 'true' ELSE 'false' END AS file_present```
