to_sql_where: consider replacing 'ST_GeomFromWKB' with 'ST_GeomFromWKT'

[huanglii]

I want to use the result converted from to_sql_where in PostGIS, as follows:

ast = parse("INTERSECTS(geom, LINESTRING(0 0, 1 1))")
where = to_sql_where(ast, FIELD_MAPPING)

The result is as follows:

ST_GeomFromWKB(x'01020000000200000000000000000000000000000000000000000000000000F03F000000000000F03F')

But it cannot be executed. It should be like this below in PostGIS:

ST_GeomFromWKB('\x01020000000200000000000000000000000000000000000000000000000000F03F000000000000F03F')

So, would you consider replacing 'ST_GeomFromWKB' with 'ST_GeomFromWKT' to avoid differences in different dialect?

[mkeller3]

@huanglii, you can write your own evaluate.py file to avoid this issue like I have in this project 😄

https://github.com/mkeller3/FastCollections/blob/main/api/filter/evaluate.py#L155