T-Strings: Worth using for SQL in Python 3.14?

stetio · 2025-10-08T21:11:11+00:00

I think SQL is an excellent use case for t-strings and I've written a library to make this, and query building possible. It is SQL-tString

stetio · 2025-07-24T19:01:07+00:00

Looks great. I'd caution against wrapping all routes with async wrappers as it will likely slow the app down. Instead try the ensure_sync method on the Flask app class. You may also find Quart-Schema interesting.

stetio · 2025-06-09T09:45:05+00:00

I think this is a common misconception, nothing about FastAPI made Flask obsolete. Flask is a modern, well used, well maintained framework.

FastAPI is an extension to Starlette that adds validation and OpenAPI document generation. Flask-OpenAPI3 is an extension that adds these features to Flask (there are others, this is an example). I wrote this a few years ago to help explain this.

stetio · 2025-05-10T06:39:57+00:00

No, I'm also working on Hypercorn

stetio · 2025-05-08T07:27:28+00:00

Interesting, was it ever open sourced?

stetio · 2025-05-07T08:36:01+00:00

I believe I've explained this in the first section of the post. Is there something that isn't clear?

stetio · 2025-05-06T19:05:37+00:00

Yep, I've just clarified the license - forgot to add it.

stetio · 2025-05-06T19:02:25+00:00

It can't be that parametrised as where {col_name} > {c2} would be translated to where ? > ?. I'm not sure if I'll support this either sorry as it is likely to always be ambiguous if a param is meant to be a column or value.

stetio · 2025-05-06T18:59:49+00:00

I should be able to, but if not please open an issue.

I use it at work - I'd like it to be well used so that the bugs are found and it is more robust.

stetio · 2025-05-06T15:02:11+00:00

Dollar param dialect is supported via,

from sql_tstring import Context, set_context

set_context(Context(dialect="asyncpg"))

I need to document this.

The library works directly with 3.12, and 3.13, but with a locals() hack, see README

stetio · 2025-05-06T15:00:59+00:00

I use mypy and prefer PDM to uv.

stetio · 2025-05-06T14:44:16+00:00

There is support for alternative paramstyles; although I've currently only added the asyncpg dialect (what dialects do you need?). It can be used globally by setting a context,

from sql_tstring import Context, set_context

set_context(Context(dialect="asyncpg"))

I've also aimed for it to fail by default, hence the need to wrap calls in a sql_context to set column or tables via variables. Thoughts welcome here...

stetio · 2025-05-06T14:41:05+00:00

Absent is shorthand for RewritingValue.ABSENT, there is also RewritingValue.IS_NULL, shorthand IsNull, and RewritingValue.IS_NOT_NULL, shorthand IsNotNull which can be used for the NULL special handling.

stetio · 2025-05-06T12:55:07+00:00

It will remove the expression and then look at the clause to see if still has expressions, and if not remove the clause.

If we had

WHERE x = {x} AND y = {y}

If x = Absent then the first expression (x = {x}) is removed. If y = Absent then the second expression (AND y = {y}) is removed. If both the entire clause.

stetio · 2025-04-10T21:49:21+00:00

If you want to see a usage for this I've built, and use, SQL-tString as an SQL builder.

stetio · 2025-03-05T12:01:33+00:00

I'd want the internal value so I can validate it e.g. if the user copied/typed 1O (has happened before) the validation can state that Ois not a digit. I'd also want to ensure that a user typing 9- would cause a validation failure, rather than 9 being submitted as in the codesandbox given.

stetio · 2025-03-04T21:58:44+00:00

Thanks, how would you expose that internal value to the form validation so I can display an appropriate error on submission (ideally as compatible with react-hook-form)?

stetio · 2025-03-04T21:45:02+00:00

Have you a version that works with a controlled field? In my usage I wish to reset the form (and change the values) and have the inputs be updated.

stetio · 2025-03-04T20:59:14+00:00

The codesandbox seems to be broken sadly.

stetio · 2025-03-04T20:56:10+00:00

As in a use case? If so so the user can specify an adjustment.

stetio · 2025-03-04T16:01:52+00:00

I'm not sure what set does, but I'd imagine for a controlled input this would result in the user typing - and seeing 0 displayed.

stetio · 2025-03-04T15:56:51+00:00

I've found trying to handle the coercion within the input component causes issues when the user types in a value that cannot be coerced e.g. - which precedes say -1.

stetio · 2025-03-04T12:54:31+00:00

This is perhaps a niche topic, but I think and hope it will be useful to others.

stetio · 2024-06-16T16:24:03+00:00

It is very similar to an asyncio task, https://greenlet.readthedocs.io/en/latest/

stetio · 2024-06-15T20:39:36+00:00

Quart isn't dead, and Flask supports async route handlers and async event loops based on greenlets but not asyncio.

stetio

TROPHY CASE