Column names are not escaped

[bergmark]

If you define a column as eg Wire "don'tdothis" opaleye will generate invalid queries.

[tomjaguarpaw]

Interesting. Is this actually a valid column name?

[bergmark]

Yep

# create table x ("id'" int);
CREATE TABLE
# insert into x ("id'") values (1);
INSERT 0 1
# select * from x;
 id'
-----
   1
(1 row)

I don't really care about this by the way, but thought it was worth mentioning.

[tomjaguarpaw]

It's definitely worth having a record of it, so thanks for pointing it out.

[tomjaguarpaw]

I think this is now fixed in Opaleye 1: tomjaguarpaw/haskell-opaleye@3d9946f