Add support for aggregate functions (COUNT, GROUP BY, HAVING)

[FireCulex]

$ sqlitis "select count('typeID'),character_id from skills  where active>0 and ('typeID'=3337 or 'typeID'=3336 or 'typeID'=12212) group by character_id having count('typeID') =3"
ERROR: Failed to convert SQL: select count('typeID'),character_id from skills  where active>0 and ('typeID'=3337 or 'typeID'=3336 or 'typeID'=12212) group by character_id having count('typeID') =3
[BUG] Failed to convert 'typeID' to model

[pglass]

Yep, not all syntax is supported yet: https://github.com/pglass/sqlitis#sql-support-checklist

[FireCulex]

Also I was using double quotes and the message is different when using single quotes?

[pglass]

Can you be more specific about the quotations?

Do you mean this, (where all quotes are single quotes)?

$ sqlitis 'select count('typeID'),character_id from skills  where active>0 and ('typeID'=3337 or 'typeID'=3336 or 'typeID'=12212) group by character_id having count('typeID') =3'