Materialize/doc/user/content/releases/v0.100.md

---

title: "Materialize v0.100" date: 2024-05-22 released: true

patch: 1

v0.100

SQL

• Add a MAP expression that allows constructing a map from a list of key–value pairs or a subquery.

  SELECT MAP['a' => 1, 'b' => 2];
  
     map
  -------------
  {a=>1,b=>2}
  

Bug fixes and other improvements

• Support the COPY TO command in the WebSocket API, so it's possible to run it from the SQL Shell.