How to write a query with a subquery in WHERE condition block (select * from where x = (select x from....))

[quirell]

Like in the title
I couldn't figure out how to write

select stations.last_updated_at AS "stations.last_updated_at",stations.kiosk_id AS "stations.kiosk_id",stations.data AS "stations.data" 
from stations 
where last_updated_at = (select MIN(last_updated_at) from stations where last_updated_at >= #at)

I know you can use From()
and I have tried it but it doesn't compile.
I'd like something along the lines of :

SELECT(Stations.AllColumns).
FROM(Stations).
WHERE(Stations.LastUpdatedAt.EQ(
	SELECT(MIN(Stations.LastUpdatedAt)).
		FROM(Stations).
		WHERE(Stations.LastUpdatedAt.GT_EQ(TimestampT(from))))
).
QueryContext(ctx, r.db, &stations)

Is it even possible ?

[houten11]

Hi @quirell, check wiki - https://github.com/go-jet/jet/wiki/Expressions#sql-builder-cast-wrapper.

[quirell]

I'm so stupid. I've looked through the wiki a couple of times and couldn't find that. Thank you so much!