REPL

List databases:

db> 
\l
List of databases:
  db
  tutorial

Connect to a database:

db> 
\c my_new_project

my_new_project>

List modules:

db> 
\lm

List object types:

db> 
\lt

List scalar types:

db> 
\lT

List expression aliases (the + includes the expression value in the listing):

db> 
\la+

Describe an object type:

db> 
\d std::Object
abstract type std::Object {
    required single link __type__ -> schema::Type {
        readonly := true;
    };
    required single property id extending std::id -> std::uuid {
        default := (SELECT
            std::uuid_generate_v1mc()
        );
        readonly := true;
    };
};

Describe a scalar type:

db> 
\d decimal
scalar type std::decimal extending std::anynumeric;

Describe a function:

db> 
\d sum
function std::sum(s: SET OF std::float64) ->  std::float64 {
    volatility := 'IMMUTABLE';
    using sql
;};
function std::sum(s: SET OF std::decimal) ->  std::decimal {
    volatility := 'IMMUTABLE';
    using sql
;};
function std::sum(s: SET OF std::bigint) ->  std::bigint {
    volatility := 'IMMUTABLE';
    using sql
;};
function std::sum(s: SET OF std::float32) ->  std::float32 {
    volatility := 'IMMUTABLE';
    using sql
;};
function std::sum(s: SET OF std::int64) ->  std::int64 {
    volatility := 'IMMUTABLE';
    using sql
;};
function std::sum(s: SET OF std::int32) ->  std::int64 {
    volatility := 'IMMUTABLE';
    using sql
;};