No offence, but that's absurd. If anyone said their database can do things almost instantly because they can write a view which is defined super quick vs mater

No offence, but that's absurd. If anyone said their database can do things almost instantly because they can write a view which is defined super quick vs materialising or running an actual query they'd be, justifiably and hopefully, laughed out of the room. But that's pretty much what you've done/contributed. Of course lazy evaluation is faster if it's so lazy it doesn't actually evaluate anything/does something completely different to the original problem. Now evaluate it and come back with a wall time...