You can use macros to replace within your query.
There is a limitation that you cannot select multi-value fields.
You can use them in condition but you cannot SELECT them
fcpc select "name FROM {epoch} WHERE tag='sys:modified:epoch'"
fcpc select "COUNT(name) FROM {epoch} WHERE object RLIKE '{host+}' AND tag='sys:modified:epoch'"
fcpc select "name,COUNT(name) FROM {epoch} GROUP BY name"
usage: fcpc select [-h] [sql ...]
positional arguments:
sql
optional arguments:
-h, --help show this help message and exit