Issues

• Support CTEs (WITH clause) in queries

  piccolo-orm/piccolo#1439 · Filter by author SahilRajputdotexe opened on Oct 2, 2026

• Prefix Unqiue constraint's index name with the table name

  piccolo-orm/piccolo#1437 · Filter by author m3ls17 opened on Sep 24, 2026
  3

• Support unique constraints with where clauses

  piccolo-orm/piccolo#1433 · Filter by author m3ls17 opened on Sep 9, 2026
  4

• Fixtures are inserted with null values while default values can be used

  piccolo-orm/piccolo#1432 · Filter by author mlbiche opened on Sep 8, 2026
  2

• Proposal: opt-in Table.filter(**kwargs) with Django-style lookups

  piccolo-orm/piccolo#1413 · Filter by author regiscamimura opened on Jul 27, 2026
  2

• postgresql partition by support

  piccolo-orm/piccolo#1380 · Filter by author chuiniudawang opened on Apr 18, 2026

• Consistent fixture ordering

  Feature

  piccolo-orm/piccolo#1378 · Filter by author dantownsend opened on Apr 16, 2026
  1

• Migration to prod

  piccolo-orm/piccolo#1253 · Filter by author Jacky56 opened on Aug 24, 2025
  2

• Compound indexes are not supported by (auto-)migrations

  piccolo-orm/piccolo#1188 · Filter by author Lordfirespeed opened on Apr 23, 2025
  5

• Disable migrations

  piccolo-orm/piccolo#1161 · Filter by author abhishek-compro opened on Mar 11, 2025
  4

• create_pydantic_model returns models with wrong fields marked as null

  piccolo-orm/piccolo#1132 · Filter by author HakierGrzonzo opened on Dec 13, 2024
  5

• Encode strings as JSON in where clauses

  bug
  piccolo-orm/piccolo#1118 · Filter by author dantownsend opened on Oct 25, 2024
  1

• Schema generation assumes incorrect default values for UUID columns

  piccolo-orm/piccolo#1070 · Filter by author Keating950 opened on Aug 22, 2024
  2

• Using db_column_name when adding columns to existing tables using auto migrations

  bug
  piccolo-orm/piccolo#945 · Filter by author dantownsend opened on Mar 11, 2024
  1

• make Readable for boolean fields more user-friendly

  piccolo-orm/piccolo#741 · Filter by author trondhindenes opened on Dec 29, 2022
  5

• Piccolo doesn't handle duplicate entries automatically for in .add_m2m

  piccolo-orm/piccolo#707 · Filter by author Drapersniper opened on Dec 5, 2022
  7

• CockroachDB: When supported, resolve "ALTER COLUMN TYPE is not supported inside a transaction"

  piccolo-orm/piccolo#632 · Filter by author gnat opened on Oct 3, 2022

• Add support for tablespaces

  enhancement
  piccolo-orm/piccolo#526 · Filter by author dantownsend opened on May 24, 2022

• Expose an API for running QueryString

  enhancement
  piccolo-orm/piccolo#406 · Filter by author dantownsend opened on Jan 25, 2022
  1

• Foreign Keys that reference non pk columns

  enhancement
  piccolo-orm/piccolo#394 · Filter by author dantownsend opened on Jan 13, 2022
  2

• Filtering with the new M2M column

  enhancement
  piccolo-orm/piccolo#381 · Filter by author dantownsend opened on Dec 23, 2021
  1

• Reverse foreign key lookups

  enhancement
  piccolo-orm/piccolo#378 · Filter by author dantownsend opened on Dec 19, 2021 · v1.0
  7

• Composite uniqueness constraints

  enhancement
  piccolo-orm/piccolo#172 · Filter by author adriangb opened on Aug 20, 2021
  1