Query syntax in Typescript sdk
Is there any way I can do this using the typescript sdk ?
Basically want to filter using calculated value
SELECT *,
(1 - (discounted_price / original_price)) * 100 AS discount_percentage
FROM products
WHERE (1 - (discounted_price / original_price)) * 100 > 20;
Basically want to filter using calculated value
SELECT *,
(1 - (discounted_price / original_price)) * 100 AS discount_percentage
FROM products
WHERE (1 - (discounted_price / original_price)) * 100 > 20;
