Blog

All The Blog Articles I Have Written Can Be Found Here

DuckDB List and Array Functions: 71 SQL Examples

A practical DuckDB reference with 71 list and array function signatures, runnable SQL examples, and expected query results.

68 min read · August 4, 2026

2026 · duckdb sql list-functions array-functions data-engineering · data engineering
Validating Patent Filing Dates with PDF Metadata Boundaries

Validating filing-date extraction against PDF creation metadata at portfolio scale.

4 min read · May 9, 2026

2026 · patent-data pdf validation data-engineering uspto · data engineering
Engineering Patent Data Delivery with Structural Invariants

Turning patent PDF extraction into analyst-ready delivery through structural invariants.

4 min read · May 9, 2026

2026 · patent-data pdf validation data-engineering uspto · data engineering
Evidence-Driven Patent PDF Processing Before Extraction

From PDF extraction to patent data delivery through strict, executable validation.

7 min read · May 9, 2026

2026 · patent-data pdf validation data-engineering uspto · data engineering
Timestamp 101 - Unit and Precision are not the same

Illustration of timestamp concepts using DuckDB, showing that unit and precision are not the same thing.

4 min read · April 9, 2026

2026 · timestamps duckdb datetime time-since-epoch dtype · data engineering