The regex used to parse table commands identified below does not currently allow for creating a table based on a query. This prevents the use of tables as materialized views.
Example
create_table :long_query,
as: "SELECT * FROM orders INNER JOIN line_items ON order_id=orders.id")generates:
CREATE TABLE "long_query" AS
SELECT * FROM orders INNER JOIN line_items ON order_id=orders.id
https://github.com/SchemaPlus/schema_plus_core/blob/master/lib/schema_plus/core/sql_struct.rb#L12-L14
The regex used to parse table commands identified below does not currently allow for creating a table based on a query. This prevents the use of tables as materialized views.
Example
generates:
https://github.com/SchemaPlus/schema_plus_core/blob/master/lib/schema_plus/core/sql_struct.rb#L12-L14