Results for “Text validation & formatting”

SQL ServerJSON & results

Read a scalar JSON property ↗

Extract a named value using a JSON path.

JSON_VALUE✓ Tested

PythonStructured data & serialization

Read a small INI configuration ↗

Python: Use ConfigParser typed accessors for configuration values stored as text.

Python✓ Tested

JavaScriptFiles & async

Read a UTF-8 file ↗

Read a small file as text using Node.js.

JavaScript✓ Tested

SQLGetting Started

Read named columns from a table ↗

SQL: Choose the columns needed and request a deterministic row order.

SQL✓ Tested

SQL ServerGetting Started

Read named columns from a table ↗

SQL Server: Choose the columns needed and request a deterministic row order.

SQL Server✓ Tested

PostgresGetting Started

Read named columns from a table ↗

Postgres: Choose the columns needed and request a deterministic row order.

Postgres✓ Tested

SQLiteGetting Started

Read named columns from a table ↗

SQLite: Choose the columns needed and request a deterministic row order.

SQLite✓ Tested

SQLWindow analytics

Read the last value of the complete partition ↗

SQL: Specify an unbounded-following frame so LAST_VALUE does not stop at the current row.

SQL✓ Tested

SQL ServerWindow analytics

Read the last value of the complete partition ↗

SQL Server: Specify an unbounded-following frame so LAST_VALUE does not stop at the current row.

SQL Server✓ Tested

PostgresWindow analytics

Read the last value of the complete partition ↗

Postgres: Specify an unbounded-following frame so LAST_VALUE does not stop at the current row.

Postgres✓ Tested

SQLiteWindow analytics

Read the last value of the complete partition ↗

SQLite: Specify an unbounded-following frame so LAST_VALUE does not stop at the current row.

SQLite✓ Tested

SQLWindow analytics

Read the next row’s value ↗

SQL: LEAD reads a later ordered row without a self join and supports a fallback at the end.

SQL✓ Tested