That's 'Stand By Me'. The pie-eating scene is legendary and is exactly as nasty as you described. The kid's name is 'Lard-Ass' Hogan. The scene is narrated by Gordie, one of the protagonists. Not gonna lie, it's gross but such a classic moment.