You can if you drill bars into the wall and provide support along the long edge. It's like partially hanging off the wall.

Then the 3 points in my previous post will become relevant in this case.

It can stay long if the starter bars are anchored properly with proper grout (as they are in tension) and the brickwalls done properly. Also the top must be sufficiently thick and the wall surface plaster should be chipped to expose the bricks. A good and experienced contractor should know this.

And it is very important to position the starter bars from the wall along the top face and not bottom face. Even at mid height it is not good enough. If starter bars and reinforcement is placed at the wrong level, then it really won't stay long.

Furthermore, he already has 2 supports at either end and the support along the edge will provide a constant hanging support, which we term cantilever.

My table top are meant to 3-4 heavy weight standing on it.