daniel
daniel
PostsComments
DTDrizzle Team
Created by daniel on 8/28/2023 in #help
Where clauses across multiple tables in relational queries
Is is possible to specify a where condition in a relational query that includes conditions from the primary table and one or more relations? e.g. 
{
  ...
  where: or(like(purchaseOrder.po,'%xxx%'), like(product.name, '%xxx%')),
}
{
  ...
  where: or(like(purchaseOrder.po,'%xxx%'), like(product.name, '%xxx%')),
}
1 replies
DTDrizzle Team
Created by daniel on 6/11/2023 in #help
InferModel including relations?
Hi, How do you use InferModel to obtain a type that includes relations? The results for an executed query has the inferred types but I'm not sure how to infer the type more generally? Thanks
16 replies
DTDrizzle Team
Created by daniel on 5/29/2023 in #help
What versions of MySQL are supported? I have JSON_ARRAYAGG issues with 5.7 and AWS Aurora Serverless
Can you confirm what versions of MySQL you intend on supporting? Relational queries with joins use JSON_ARRAYAGG which is not supported by earlier versions of 5.7 including AWS Aurora Serverless v1.
4 replies