Ask HN: Market/Customers for No-Code Products?

My former colleague reached me out recently with offer to join his startup to build MVP of no-code web development platform. Such products might look interesting at the beginning, but I'm sure many tried and many failed, hence I want to understand:

1. Who are the customers of no-code products?

2. Do these customers stay in the long-term?

3. What are the top challenges that killed such startups?

4. In 5 years time, would we have more and significantly successful no-code products?

5. At what extent a customer might prefer a no-code tool over signing a contract with consultancy?