# SQL Query Property Binding Missing in Perspective

**URL:** <https://forum.inductiveautomation.com/t/sql-query-property-binding-missing-in-perspective/25157>\
**Category:** Ignition\
**Tags:** ignition80\
**Created:** [May 20, 2019, 3:57pm UTC](https://forum.inductiveautomation.com/t/sql-query-property-binding-missing-in-perspective/25157 "2019-05-20T15:57:55Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![roger\_larson](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/roger_larson/32/8574_2.png) [@roger\_larson](https://forum.inductiveautomation.com/u/roger_larson)\
**Post date:** [May 20, 2019, 3:57pm UTC](https://forum.inductiveautomation.com/t/sql-query-property-binding-missing-in-perspective/25157/1 "2019-05-20T15:57:55Z")

</div>

Hi all,

Is there currently no way to configure a SQL Query property binding aside from a named query or a runScript expression in 8.0 Perspective? I believe we were able to write the Query within the binding manually if needed.

Or am I missing a better solution here? The use case is to containerize this query in a template/view that I can share around. It works fine for tags/named queries/runScripts, but I would like to avoid these if I can.

Cheers,  
Roger

---

<div class="post-metadata">

**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\
**Post date:** [May 20, 2019, 4:06pm UTC](https://forum.inductiveautomation.com/t/sql-query-property-binding-missing-in-perspective/25157/2 "2019-05-20T16:06:47Z")

</div>

Direct SQL queries are deliberately absent from Perspective - they’re 1. a big security problem and 2. harder to optimize.  
If you can’t achieve what you want with named queries, then DB access through scripting is the recommended approach.

---

<div class="post-metadata">

**Author:** ![roger\_larson](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/roger_larson/32/8574_2.png) [@roger\_larson](https://forum.inductiveautomation.com/u/roger_larson)\
**Post date:** [May 20, 2019, 4:09pm UTC](https://forum.inductiveautomation.com/t/sql-query-property-binding-missing-in-perspective/25157/3 "2019-05-20T16:09:10Z")

</div>

Ahhh, makes sense! Thanks for the info. I think we’ll use the named query approach for this particular view, I’ve used it everywhere else but this window.

Best,  
Roger