On a sunny day, would the air over a piece of land be cooler than the air over a bordering lake?

Yes because the cool air from a near by water source migrates toward the land to take the place of the hot air rising while the air over an area of water would be warmer because it is absorbing solar energy from the sun