Multiple conditions for chatflow execution

[simosme]

I am looking for (paid if appropriate) help with a chatflow. I have a functioning chatflow using RAG. I would like to achieve the following and haven't found a way yet:

1. When the chatflow receives a message

2. If the message is equal to a specific question (a starter prompt)
   2a) the chatflow runs a simple (non-embedding-based) SQL query on my SQL database (Supabase)
   2b) else: the chatflow executes the main route (RAG-based chat) - this is already up and running

I tried using the if/else node without success. I also tried ways to call children flows without success. I would be very grateful if you have any ideas or pointers that can help me understand the right approach. I am happy to pay for consultations/in-depth help.