0.12.34

• Add ability to quote/unquote cursor. #1403

0.12.33

• Add BaseSelect type hint for SQLModel paginate. #1365
• Fix issue with sqlalchemy.paginate with session + session.query case. #1384
• Bump dependencies versions. #1379

0.12.32

• Add support for sqlalchemy CompoundSelect. #1361

0.12.31

• Add NotImplementedError to ignored exc when resolving unwrap-mode. #1324

0.12.30

• Fix issue when select model with single field. #1317

NOTE! This is last release before 0.13.0 version.

0.12.29

• Fix issue with sqlalchemy scalar select detection. #1313
• Add unwrap mode for sqlalchemy ext. #1316

New Feature

sqlalchemy unwrap_mode allows you to control how to unwrap result rows before passing them to items transformer
and page creation.

unwrap_mode can be set to one of the following values:

• None - will use auto mode for default queries, and legacy for text and from_statement queries.
• "auto" - will unwrap only in case if you are selecting single model.
• "legacy" - will use old behavior, where row will be unwrapped if it contains only one element.
• "unwrap" - will always unwrap row, even if it contains multiple elements.
• "no-unwrap" - will never unwrap row, even if it contains only one element.

0.12.28

• Add better logic for sqlalchemy scalars unwrapping. #1281
• Fix issue with sqlalchemy imports for gino ext. #1282
• Fix issue with incorrect body schema. #1299

Breaking changes

sqlachemy extension no longer requires to use items_transformer when selecting scalar field:

This code is no longer valid:

paginate(session, select(User.name), transformer=lambda items: [{'name': item} for item in items])

The correct version now is:

paginate(session, select(User.name))

0.12.27

• Bump to next pytest-asyncio version. #1118
• Bump to next fastapi version. #1275
• Support total parameter for tortoise ext. #1269
• Add support for sqlalchemy from statement. #1277

0.12.26

• Fix issue with passing count_query into sqlalchemy/sqlmodel. #1194
• Add ability to use async length_function with async_paginator. #1204
• Fix incorrect total number in page when paginating beanie query with fetch_links=True. #1199

Thanks to @moumoutte and @IterableTrucks!

0.12.25

• Fix issue with databases + sqlalchemy 2.0. #1160
• Move FastAPI to dev dependencies. #1175
• Add UseAdditionalFields customization. #1180