Google offers as much of a description:
An easy way to learn how to use an API can be to look at sample code. The table above provides links to some basic samples for each of the languages shown. This section highlights particularly interesting samples for the Fusion Tables API.
I’ve tried to gather my Fusion Tables knowledge here.
You can now find the following samples from Google FT:
Changing the layer on query