Write data to database from query

Hi everyone, I was wondering if there was an easy way to write data to a database from the results of a query, like the equivalent of the follow SQL statement:

CREATE TABLE table_x AS SELECT * FROM table_y;
or perhaps
INSERT INTO table_x SELECT * FROM table_y;

InfluxQL has the SELECT INTO syntax.
https://docs.influxdata.com/influxdb/v1.8/query_language/explore-data/#the-into-clause

Watch out because without using also GROUP BY * you will lose all your tags (or better they will be stored as fields)

Thank you, so much! I’m new to influx so I apologize if this seems so trivial.