go-jet

Note that generate_series can be used as table source and expression: ```sql SELECT * FROM generate_series(2,4); -- table source ``` ```sql SELECT generate_series(2,4); -- expression ``` With this PR the...

I guess we can go with just expression form, and revisit the other form if needed.

Unfortunately, [customizing](https://github.com/go-jet/jet/wiki/FAQ#how-to-use-customor-currently-unsupported-functions-and-operators) table sources is not supported, you'll have to fallback to [RawStatements](https://github.com/go-jet/jet/wiki/Statements#raw-statements).

Forgot to mention, if your TABLESAMPLE table is part of bigger join, you can avoid making the whole statemnet raw statement, by moving just TABLESAMPLE table into CTE or sub-query....

I agree with making `setStatement` public. Regarding the use of a subquery (or `SelectTable`) as a CTE, this appears to be an unintentional side effect of adding support for [VALUES](https://github.com/go-jet/jet/wiki/VALUES)...

Could you give a complete example, I'm having a problem to follow.

Yeah, it makes sense. I guess we could add a new flag `StrictFieldMapping`.

As code of interest - at this [line](https://github.com/go-jet/jet/blob/fb7c376ba512ccac9e9346245c38c20407c91842/qrm/scan_context.go#L257) unuesed field is identified. And for the tests - we can set this new `StrictFieldMapping` flag for either mysql or sqlite tests,...

Hi @arjen-ag5, thanks for starting the work on arrays.

> Hi I'm also interested in this functionality and I'm happy to push this work along if needed! > > Do we know what needs to be done before this...