Statement Quick Reference
=========================

.. list-table::
   :header-rows: 1
   :widths: 45 55

   * - Statement
     - Purpose
   * - ``create bucket <name> (<schema>)``
     - Create a bucket; error if it already exists.
   * - ``create unique bucket <name> (<schema>)``
     - Create a bucket only if it does not already exist.
   * - ``create forced bucket <name> (<schema>)``
     - Always create the bucket, dropping any existing one.
   * - ``create forced unique bucket <name> (<schema>)``
     - Drop and recreate if exists; create if not.
   * - ``create ... bucket <name> from csv("<file>")``
     - Create and populate a bucket from a CSV file.
   * - ``truncate <bucket>``
     - Remove all records; preserve schema.
   * - ``drop <field> from <bucket>``
     - Permanently remove a field from the schema and all records.
   * - ``describe <bucket>``
     - Print the bucket's field schema.
   * - ``show buckets``
     - List all buckets.
   * - ``insert into <bucket> (<values>)``
     - Insert a single record (positional or named).
   * - ``insert into <bucket> ([...], [...])``
     - Insert multiple records in one statement.
   * - ``get <fields> from <bucket>``
     - Retrieve records, with optional projection, filtering, and ordering.
   * - ``get head(<n>) from <bucket>``
     - Retrieve the first *n* records.
   * - ``get tail(<n>) from <bucket>``
     - Retrieve the last *n* records.
   * - ``set <bucket> (<assignments>) where <cond>``
     - Update all matching records.
   * - ``delete from <bucket> where <cond>``
     - Delete all matching records.
   * - ``export <bucket> to csv("<file>")``
     - Export all records to a CSV file.
   * - ``analyze <bucket> <field> stream(<n>)``
     - Sliding-window real-time metrics.
   * - ``analyze <bucket> <field> timeseries``
     - Trend detection, forecasting, and anomaly detection.
   * - ``analyze <bucket> <field> statistics``
     - Comprehensive descriptive statistics.
   * - ``analyze <bucket> <field> correlation(<field2>)``
     - Pearson correlation between two fields.
   * - ``analyze <bucket> <field> percentile(<n>)``
     - The *n*-th percentile value.
   * - ``analyze <bucket> <field> window(<func>, <n>)``
     - Per-row window function (``row_number``, ``rank``, ``dense_rank``, ``percent_rank``).
   * - ``begin!``
     - Begin an explicit transaction block.
   * - ``commit!``
     - Commit the current transaction (explicit or implicit).
   * - ``rollback!``
     - Roll back all changes in the current explicit transaction block.
   * - ``print "<message>"``
     - Write a string to standard output.