Hello, Is it possible to create temp tables or even normal tables through SuiteQL?

You can use CTEs. The connection is read only

That worked out, thank you!