wsporto

Results 6 comments of wsporto

Thanks for your feedback. Without the parenthesis works, but I have some problems: 1. The query `SELECT * FROM mytable WHERE id in ?` is not a valid SQL according...

I implemented a similar approach in [typesql](https://github.com/wsporto/typesql) (similar to this library, but for mysql). You can have dynamic type safe ORDER BY but with some limitations. For example, you can't...

The documentation shows an example of a one-to-one relationship between customers and addresses in the section "One To One". https://typesql.pages.dev/guides/nested-query-result/ In that case each user will have a single address...

I have been exploring this feature in [TypeSQL](https://github.com/wsporto/typesql) (a similar library but for mysql). The approach I have used is to annotate the queries with `-- @nested` as below: ```sql...

I see are some problems with this solution. For example: 1. The SQL is not a valid SQL anymore. You can't copy and run it in a SQL editor. 2....

Thank you for the suggestion! The `typesql.config.ts` file is something I plan to include in a future release.