"Hector the Hero" does get played here in the Borders a fair bit. "Highland Cathedral" is another modern pipe tune -it was not written by Scots but is very popular here. What about something like "Callum's Road" or "Dundas Loch" Accordian tunes right enough but some fiddlers hereabout play them. Yes doing Flower of Scotland tends to get people singing so maybe not the best whilst actually eating. I think Jack is right in that there aren't tunes specifically for St Andrews Day. The day has only been a public holiday for about a decade and people don't celebrate it like the Irish do St Patrick's Day or even like the Scots celebrate Burns Night - but lots of people do mark it with maybe dinners etc. Quite low key though not totally ignored.