error - [where variable is not null], [where variable != '']

[wingsuiting]

Hi, thank you for the great package!
Could I ask if there is any way to achieve checks for empty/null fields?

Example:
"""SELECT variable FROM table WHERE variable != '' LIMIT 100"""

Returns:

Invalid query!
Expected one of the following input(s): {'__ANON_5'}
Unexpected input at line 3, column 56
lding_building_name_building_number != ''

[zbrookle]

@wingsuiting Thanks! I appreciate you using my package! That's actually a good catch, I didn't have a test for that, but it should work. I'll let you know when that's patched

[wingsuiting]

Thank you! I did spot one more bug (feature?) where subqueries also experience syntax errors: SELECT variable_1, variable_2 FROM table_1 WHERE variable_2 IN (SELECT variable_3 FROM table_2)

…

On Mon, 30 Nov 2020 at 16:48, Zach Brookler ***@***.***> wrote: @wingsuiting <https://github.com/wingsuiting> Thanks! I appreciate you using my package! That's actually a good catch, I didn't have a test for that, but it should work. I'll let you know when that's patched — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub <#41 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AC2E7AHKHTEJMKXQSQ7L2C3SSPEG7ANCNFSM4UG3GZ6A> .

[zbrookle]

@wingsuiting Awesome! If you could actually make a separate issue for that, it would be really helpful

[wingsuiting]

Of course, that's done!