Apologies for my poor english.
Try this:
SQLQuery1.SQL.Add('SELECT [SessionID], [Identifier], [SessionType.SessionTypeName], [CameraID], [Date] FROM [Session] ');
In the past I became mad with a similar problem, and I solved it using ODBCConnection.ExecuteDirect instead of SQLQuery, and closing all the fields and the table´s name with symbols [ ]