✅ v2.7.4 Enforce TZ-aware columns as UTC, add dynamic queries.

[bmeares]

v2.7.3 – v2.7.4

• Allow for dynamic targets in SQL queries.
  Include a pipe definition in double curly braces (à la Jinja) to substitute a pipe's target into a templated query.

  import meerschaum as mrsm
  
  pipe = mrsm.Pipe('demo', 'template', target='foo', instance='sql:local')
  _ = pipe.register()
  
  downstream_pipe = mrsm.Pipe(
      'sql:local', 'template',
      instance='sql:local',
      parameters={
          'sql': "SELECT *\nFROM {{Pipe('demo', 'template', instance='sql:local')}}"
      },
  )
  
  conn = mrsm.get_connector('sql:local')
  print(conn.get_pipe_metadef(downstream_pipe))
  # WITH "definition" AS (
  #     SELECT *
  #     FROM "foo"
  # )
  # SELECT *
  # FROM "definition"

• Add --skip-enforce-dtypes.
  To override a pipe's enforce parameter, pass --skip-enforce-dtypes to a sync.

• Skip enforcing custom dtypes when enforce=False.
  To avoid confusion, special Meerschaum data types (numeric, json, etc.) are not coerced into objects when enforce=False.

• Fix timezone-aware casts.
  A bug has been fixed where it was possible to mix timezone-aware and -naive casts in a single query. This patch ensures that this no longer occurs.

• Explicitly cast timezone-aware datetimes as UTC in SQL syncs.
  By default, timezone-aware columns are now cast as time zone UTC in SQL. This may be skipped by setting enforce to False.

• Added virtual environment inter-process locks.
  Competing processes now cooperate for virtual environment verification, which protects installed packages.

---

This discussion was created from the release ✅ v2.7.4 Enforce TZ-aware columns as UTC, add dynamic queries..