[Vince]

You have two options. You can use either or both. First is to use Zeex' fixed compiler that allows longer lines, second is to create view. A view is basically the output of a query that is presented as a virtual table and which can be read (but not written to) like any other table, e.g.

PHP Code:

CREATE VIEW CharacterInteraction AS SELECT characters.id, ... 


And then when you do

PHP Code:

SELECT * FROM CharacterInteraction 


You'll get the output of the query that's behind it in real time.