The best suitable foundation for your case is bored cast-insitu pile..screw pile is very difficult to drive in dense sandy soil conditions..also, driven pile is not suitable in top soft clay layer..so the best option is bored pile..ok all the best in your research..
Before you choose the proper piling technology (or soil improvement method), you need to define the loads applied and the requirement concerning admissible settlements. Just for the proper design purpose.
You also have to consider the cost of mobilization of piling equipment (piling rigs), availability of materials (concrete, steel piles, precast concrete piles), Availability of building site for heavy piling rigs and so on ... All the issues related to proper and safe execution of the works.
But if you ask just about suggested technology :-)
In Scandinavian countries they would use driven open end steel pipe piles or driven precast piles. In Europe - bored piles or CFA piles. For small loads I'd suggest displacement piles (with a special regard to their embedment length into the non-cohesive soil. So you may be right with your suggestion about screw piles ;-)