Zoho Creator is an online platform that makes it easy for users to build digital database applications without any prior coding experience or IT knowledge. It's a powerful product that allows you to assemble the components you need, add the logic, and you're ready to go. With Zoho Analytics, you can even run SQL queries of any dialect on the data. The main purpose of Zoho Creator is to be an online app creation environment, which comes with a database to complete the app creation experience.
It's a closed source proprietary solution, so you're somewhat at Zoho's mercy for answers to your programming questions. With Zoho Creator, the apps you build or install from AppDeck are automatically available on iOS and Android devices. Zoho Creator helps you gain greater control of your business processes, increase efficiency and save time with automated workflows. It will provide SQL-level APIs, so you can build Zoho DB-backed applications in your own preferred language.
Some of Zoho DB's features will eventually make their way into Sheet, and it will be possible to move some of Sheet's structured data to DB, but the two products retain their distinct core identity. Zoho Creator queries are primarily intended for application development, so they are not as sophisticated as what you can do with SQL. Despite the shortcomings I have expressed, I would still recommend Zoho Creator for businesses looking to digitise their operations without the hassle of traditional development. It's used by entrepreneurs, small businesses, educational institutes and even non-profit organisations.
So it's worth considering the difference between Zoho Creator and newcomer Zoho DB.