v.1.1.54310New Feature

Added CREATE MATERIALIZED VIEW Query for Data Storage

Added the CREATE MATERIALIZED VIEW x TO y query (specifies an existing table for storing the data of a materialized view).
Added support for the CREATE MATERIALIZED VIEW x TO y query, allowing the specification of an existing table for storing the data of a materialized view.

Why it matters

This feature enables users to define a materialized view that writes its output directly into an existing table, rather than creating a new target table automatically. It provides more control over data storage, simplifies management of materialized views, and is useful when users want to consolidate or reuse storage tables for materialized views.

How to use it

Use the statement CREATE MATERIALIZED VIEW x TO y AS SELECT ... where x is the name of the materialized view and y is the existing table into which the materialized view data will be stored. For example:

CREATE MATERIALIZED VIEW <code>mv_name</code> TO <code>target_table</code> AS
<code>SELECT</code> ... <code>FROM</code> ...