I have been enjoying honeycode for a project, but ran into my first blocker that I cannot work around.
I have two tables, listed below. i want to do something SQL-like to create an aggregated list of ingredients for a shopping list (IE, combine garlic from all recipes into one line item).
Is this possible in any way in honey code?
Select
meal_event_details.recipe_name,
recipe_ingredients.ingedient,
recipe_ingredients.unit,
SUM(recipe_ingredients.quantity)
FROM meal_event_details
LEFT JOIN recipe_ingredients ON meal_event_details.recipe_name = recipe_ingredients.recipe_name
GROUP BY
meal_event_details.recipe_name,
recipe_ingredients.ingedient,
recipe_ingredients.unit,
Table 1: recipe_ingredients:
recipe_name | ingredient | quantity | unit |
---|---|---|---|
Tomatoes with sumac shallots and pine nuts | shallot | 70.00 | g |
Tomatoes with sumac shallots and pine nuts | sumac | 1.50 | pinch |
Tomatoes with sumac shallots and pine nuts | white wine vinegar | 2.00 | tsp |
Tomatoes with sumac shallots and pine nuts | tomato | 700.00 | g |
Tomatoes with sumac shallots and pine nuts | olive oil | 2.00 | tbsp |
Tomatoes with sumac shallots and pine nuts | basil | 15.00 | g |
Tomatoes with sumac shallots and pine nuts | pine nut | 25.00 | g |
spicy moroccan carrot salad | carrot | 2.00 | lb |
spicy moroccan carrot salad | olive oil | 0.33 | cup |
spicy moroccan carrot salad | onion | 1.00 | ea |
spicy moroccan carrot salad | sugar | 1.00 | tsp |
spicy moroccan carrot salad | garlic | 3.00 | clove |
spicy moroccan carrot salad | green chili | 2.00 | ea |
spicy moroccan carrot salad | green onion | 1.00 | ea |
spicy moroccan carrot salad | ground clove | 0.13 | tsp |
spicy moroccan carrot salad | ground ginger | 0.25 | tsp |
spicy moroccan carrot salad | ground coriander | 0.50 | tsp |
spicy moroccan carrot salad | ground cinnamon | 0.75 | tsp |
spicy moroccan carrot salad | paprika - sweet | 1.00 | tsp |
spicy moroccan carrot salad | ground cumin | 1.00 | tsp |
spicy moroccan carrot salad | white wine vinegar | 1.00 | tbsp |
spicy moroccan carrot salad | preserved lemon | 1.00 | tbsp |
spicy moroccan carrot salad | cilantro | 2.50 | cup |
spicy moroccan carrot salad | greek yogurt | 0.50 | cup |
spiced shepherd’s pie with lima bean crust | olive oil | 6.00 | tbsp |
spiced shepherd’s pie with lima bean crust | garlic | 3.00 | clove |
spiced shepherd’s pie with lima bean crust | shallot | 3.00 | ea |
spiced shepherd’s pie with lima bean crust | ground beef | 600.00 | g |
spiced shepherd’s pie with lima bean crust | cumin seed | 2.00 | tsp |
spiced shepherd’s pie with lima bean crust | allspice | 1.00 | tbsp |
spiced shepherd’s pie with lima bean crust | lemon | 2.00 | ea |
spiced shepherd’s pie with lima bean crust | tomato paste | 3.00 | tbsp |
spiced shepherd’s pie with lima bean crust | harissa | 3.00 | tbsp |
spiced shepherd’s pie with lima bean crust | apricots | 100.00 | g |
spiced shepherd’s pie with lima bean crust | chicken stock | 280.00 | ml |
spiced shepherd’s pie with lima bean crust | white wine | 220.00 | ml |
spiced shepherd’s pie with lima bean crust | green olive | 80.00 | g |
spiced shepherd’s pie with lima bean crust | lima bean | 670.00 | g |
spiced shepherd’s pie with lima bean crust | tahini | 70.00 | g |
smoky marinated feta | garlic | 10.00 | clove |
smoky marinated feta | lemon | 1.00 | ea |
smoky marinated feta | bay leaf | 4.00 | ea |
smoky marinated feta | chipotle chili flake | 2.50 | tsp |
smoky marinated feta | olive oil | 250.00 | ml |
smoky marinated feta | sea salt | 1.00 | tsp |
smoky marinated feta | paprika | 1.25 | tsp |
smoky marinated feta | feta | 360.00 | g |
Shatta | tomato | 90.00 | g |
Shatta | fresno chili | 180.00 | g |
Shatta | kosher salt | 0.50 | tsp |
Shatta | apple cider vinegar | 3.00 | tbsp |
Shatta | olive oil | 8.00 | tbsp |
honey roasted carrots with tahini yogurt | honey | 3.00 | tbsp |
honey roasted carrots with tahini yogurt | olive oil | 2.00 | tbsp |
honey roasted carrots with tahini yogurt | coriander seed | 1.00 | tbsp |
honey roasted carrots with tahini yogurt | cumin seed | 1.50 | tsp |
honey roasted carrots with tahini yogurt | thyme sprig | 3.00 | ea |
honey roasted carrots with tahini yogurt | carrot | 3.00 | lb |
honey roasted carrots with tahini yogurt | cilantro | 1.50 | tsp |
honey roasted carrots with tahini yogurt | tahini | 3.00 | tbsp |
honey roasted carrots with tahini yogurt | greek yogurt | 130.00 | g |
honey roasted carrots with tahini yogurt | lemon juice | 2.00 | tbsp |
honey roasted carrots with tahini yogurt | garlic | 1.00 | clove |
Table 2: meal_event_details
event_date | meal_type | meal_component | recipe_name |
---|---|---|---|
12/30/20 | dinner | main | spiced shepherd’s pie with lima bean crust |
12/30/20 | dinner | side | honey roasted carrots with tahini yogurt |