August 2024 new features, fixes, and improvements

Improvements

Console

• Developers can now sign up and sign in using their Google account.
• Developers can now sign up and sign in using their GitHub account.

SQL

• Enhanced support for ClickHouse and PostgreSQL array functions.
• Introduced new ClickHouse SQL functions:
  • arrayJoin: Allows for the expansion of arrays into separate rows.
  • JSONExtractArrayRaw: Extracts an array from a JSON string.
  • JSONExtractKeys: Retrieves keys from a JSON object.
  • JSONArrayLength: Determines the length of a JSON array.
• Added ClickHouse tuple manipulation functions:
  • tupleNames: Returns the names of tuple elements.
  • tupleElement: Extracts a specific element from a tuple.
• Added ClickHouse geospatial functions for advanced geographical data processing.