Hi,
is it possible to put SQL-Select-Functionality into the template-system?
e.g.

<%select Links.URL,COUNT(*) from Links where URL=http://www.test.com GROUP BY URL;%>
and the result would be: "34"

So i need the functionality to set sql-commands (Selects, Update, Delete) and include tags from "User-table" into it.
eg.
<%select User.Name,COUNT(*) from User where Name Like %%Name%% GROUP BY Name;%>

%%Name%% is equal with <%Name%>, a field from User-table.

I know, that this is dangerous for the DB, but:
Would be a global or plugin make it possible to implement this feature?

Thanks in advance!

Corc