In sq files, allow escaping raw SQL in where clauses with no parameters

[tropikoder]

I'm trying to do this, which has a valid where clause (in Postgres) and I get an error in the where clause. (The error is: "No column found with name age")

Since there are no parameters in the where clause, would it be possible to indicate that the parser should treat it as raw sql?

getPostsPublishedThisWeekCnt:
SELECT count(*) FROM Posts
WHERE age(TIMESTAMP 'epoch' + date_created * INTERVAL '1 millisecond') < INTERVAL '1 week'

[tropikoder]

I should mention that there is an easy work-around for this (WHERE date_created > ?) so this is not high priority

[AlecKazakova]

I'm gonna close this one out, if I'm understanding correctly your using shorthand syntax to cast columns. Though we could try and add support for it in the parser its challenging because it wants to think that TIMESTAMP is a column name. There's a sql-standard way to do casting which I've added a test for here that we'll probably just make the only supported way to do casting. I'm open to coming back to this if it becomes a bigger deal but I suspect just using a CAST statement is fine for most if not all cases.