The no-code approach
I cannot imagine building a database of any complexity without coding. If you have a no-code design environment, then you will have to have modules and you will be constrained by what the modules allow. The modules will only allow for what has been coded in them by actual developers and the no-code approach means you can't modify them in any way.
So the only "applications" you can make are the ones that correspond to the modules' abilities. If what you need lies outside that scope, you can't build it.
There may well be some types of application that benefit from this approach, but I can't see people building everything they need simply with a drag-and-drop environment.