'SelectFrom' object has no attribute 'Columns'

[ifuchs]

Tried the following:

sqlitis 'SELECT DISTINCT last_name, first_name,addressee_display, street_address, city, a.name, postal_code, f.name as country FROM civicrm_contact c, civicrm_entity_tag d , civicrm_address e, civicrm_state_province a, civicrm_country f WHERE c.id = d.entity_id and tag_id = 6 and c.id = e.contact_id AND state_province_id = a.id and e.country_id = f.id and display_name not in ( SELECT display_name FROM civicrm_contribution, civicrm_contact c, civicrm_entity_tag d WHERE contact_id = c.id and c.id = entity_id and tag_id = 6'

Got: 'SelectFrom' object has no attribute 'Columns'

[pglass]

First thing is it looks like sqlitis doesn't support commas for joining tables (e.g. FROM a JOIN b JOIN c works but FROM a, b, c does not). That should be an easy fix.

The harder thing is that sqlitis doesn't support table aliases yet. There's a lot to that, so created a separate issue for it (#23)