Is it possible to get QL object back from influx SQL statement?

This would help in many use cases where we want to analyze the incoming SQL statements before it goes to influx database.

How do I construct the following InfluxDB query?
select id from EMP where (dept = 'Eng' and sal < 10 or dept = 'Sales' and sal > 15) and country = 'US'

When running ql.condition({}) the resulting query is like "select * from measurement where".

Influx now supports selecting from multiple measurements:

select * from "msmt_1", "msmt_2"

When grouping by time with an offset the query returns a error.

group by "time(86400s, 120m)"
ERR: difference aggregate requires a GROUP BY interval

If I remove the " " before and after the time parameter

group by time(86400s, 120m)

the query returns correctly.

When grouping by time without offset works even with " "

Influx Version 1.5.1

Trying to query select one,two,three from stats where myCond='40002' or myCond='40007' and time <= 1463142720s and time >= 1463142660s

Tried with

const reader = client.query('stats');
reader.addField('one', 'two', 'three');
reader.start = start;
reader.condition("myCond='40002' or myCond='40007'");

In this case the condition is ignored. If I only enter one condition without "or" operator it is considered and included in the query.

How can I add several conditions on the same field as one would do with "or" operator?

If you try to use .where to specify a condition based on field or tag value then influx-ql will add single quotes to it and therefore comparison fails.

For example if you want to query integer values by bitwise operator you need to have ability to skip single quoting .where value.

const typeMask = 1023
const ql = new QL()
ql.measurement = "test";
ql.where(
  {
    type_mask: '"type_mask"',
  },
  `| ${typeMask} =`,
)
console.log(ql.toSelect())
/* 
  log output: select * from "test" where "type_mask" | 1023 = '"type_mask"'
  ✓ correct output: select * from "test" where "type_mask" | 1023 = "type_mask"
*/

const QL = require("influx-ql");
const ql = new QL('mydb');
ql.measurement = 'http';
ql.addField('"use" - 2');
console.info(ql.toSelect());

Above code is not working (expression is wrapped in double quote). See the below generated query.
select ""use" - 2" from "mydb".."http"
Where as if the expression is '"use" + 2', then it works.
select "use" + 2 from "mydb".."http"

Currently ql.start and ql.end don't work with javascript Date Object. I think it would be nice to add support for them, even if I pass a date string it isn't quoted in query result:

Javascript:

    var end = new Date();
    var start = new Date(Date.now() - (24*60*60*1000)); //last day
    var ql = new QL();
    ql.measurement = point.measurement;
    ql.addFunction('mean', 'value');
    ql.condition(point.tags);
    ql.start = start.toString();
    ql.end = end.toString();

    var query = ql.toSelect();

    console.log(query);

Output:

select mean("value") from "temperature" where ("location0" = 'garage' and "device" = '_thermo1') and time <= Thu Jan 25 2018 16:19:46 GMT+0100 (CET) and time >= Tue Jan 23 2018 04:19:46 GMT+0100 (CET)

There is also no support for GROUP BY time intervals (Example: GROUP BY time(interval[unit])) and for nested functions (Eample DIFFERENCE(first(value))

UPDATE:

At the moment I have been able to use Javascript dates by using a function to convert timestamp to nano string:

function dateToNano(date){
  return (date.getTime() * 1000000).toString();
}

......
    var end = new Date();
    var start = new Date(Date.now() - (24*60*60*1000)); //last day

    var ql = new QL();
    ql.measurement = point.measurement;
    ql.addFunction('mean', 'value');
    ql.condition(point.tags);
    ql.start = dateToNano(start);
    ql.end = dateToNano(end);

    var query = ql.toSelect();

Any plans for CQ support?

Hi how can i do this query:

select count(distinct(userId)) as value from heartbeat where time > now() - {} GROUP BY time({}) fill(0)

My porblem is with composed function:

count(distinct(userId))

I'm expecting many issues when using subQuery() method.

The fields I have checked are duplicated are ql.start ql.end ql.addGroup ql.tz`

If I set those values in the subQuery those values are added to the main query too and this is not the expected behaviour.

Example

Expected:

select sum(value) as "value"
from (
select difference(value) as "value" 
from "temperature"
where "tag1" = 'max' and time <= 1553096174000000000 and time >= 1521560174000000000 tz('Europe/Rome')
) 
group by time(1d) fill(none)

Got:

select sum(value) as "value"
from (
select difference(value) as "value" 
from "temperature"
where "tag1" = 'max' and time <= 1553096174000000000 and time >= 1521560174000000000 
group by time(1d) fill(none) <-- duplicated
tz('Europe/Rome') 
) 
where time <= 1553096174000000000 and time >= 1521560174000000000 <-- duplicated
group by time(1d) fill(none)
tz('Europe/Rome') <-- duplicated