v0.44.0

Added

• New SLQ function rownum() that returns the one-indexed row number of the current record.

  $ sq '.actor | rownum(), .actor_id, .first_name | order_by(.first_name)'
  rownum()  actor_id  first_name
  1         71        ADAM
  2         132       ADAM
  3         165       AL

• sq inspect has two new flags:

  • --schemata: list the source's schemas

    $ sq inspect @sakila/pg12 --schemata -y
    - schema: information_schema
      catalog: sakila
      owner: sakila
    - schema: public
      catalog: sakila
      owner: sakila
      active: true

  • --catalogs: list the source's catalogs

    $ sq inspect @sakila/pg12 --catalogs
    CATALOG
    postgres
    sakila

Fixed

• sq version now honors option format.datetime when outputting build timestamp.
• Fixed a fairly nasty bug that prevented correct rendering of SLQ functions nested inside an expression.

Changed

• The --exec and --query flags for sq sql were removed in the preceding release (v0.43.1).

  That was probably a bit hasty, especially because it's possible those flags could be reintroduced when the query vs exec situation is figured out. So, those two flags are now restored, in that their use won't cause an error, but they've been hidden from command help, and remain no-op.