используйте подзапрос, затем вы можете найти математическую формулу, которая действует, чтобы дать желаемые значения, таким образом вы можете исключить фактическую булеву логику и заменить ее математическими функциями, например
SELECT *,(1 - ceiling(cos(atan(abs(cast(x as float)))) -
floor(cos(atan(abs(cast(x as float))))))) +
x * ceiling(cos(atan(abs(cast(x as float)))) -
floor(cos(atan(abs(cast(x as float)))))) as Computed
FROM
( select 0 as x union SELECT 1 X UNION SELECT -.123 UNION SELECT 9.1 UNION SELECT 67000 union select -1) OQ
I'm not sure about Tkabber, but there are various clients that'll let you play with PubSub. None of them exposes innovative user interfaces that leverages the unique concepts of PubSub : they are mostly developer tools for basic CRUD in the service discovery node tree. But maybe this is just what you need...
Instant messaging clients with PubSub service discovery :
Specialized PubSub administration clients :