Can you use a raw value for FROM?

[Jleagle]

Hi, i am trying to make this:
FROM metric LEFT JOIN LATERAL jsonb_each_text(metric.data) AS kv(key, value) on true

For clauses and expressions i can create a raw string and enter whatever i like, but for FROM i need a ReadableTable and i cant see a raw type for this. I also cant seem to create my own struct that implements ReadableTable and serialises out to my string as there are some types in the internal directory i would need.

Any ideas? Thanks.

[go-jet]

No, currently it is not possible, but there is a workaround. You can move your unsupported from tables into a CTE or sub-query with a raw statement. Check faq.

In your case kv depends of metric, so metric needs to be moved as well:

key := StringColumn("key")
value := StringColumn("value")

kv := CTE("kv", key, value)

stmt := WITH(
	kv.AS(
		RawStatement(`
			select kv.* // or select metrics.*, kv.*
			from metric
			left join lateral jsonb_each_text(metric.data) as kv(key, value) on true
		`),
	),
)(
	SELECT(kv.AllColumns()). // or SELECT(key, value)
	FROM(
		kv.INNER_JOIN(...),
	),
)