Hi, just hacked something with the dashboard-2.
You can ignore it, if it is not relevant for you. i just wanted to try it out 
Dashboard 2 and a sqlite db: a very simple login/logout app:

[{"id":"8e6b07d1688aac0d","type":"tab","label":"Flow 1","disabled":false,"info":"","env":[]},{"id":"b8ae4b7d1b7f9009","type":"ui-table","z":"8e6b07d1688aac0d","group":"3c68ea2ef8aaa739","name":"","label":"text","order":1,"width":"0","height":"0","maxrows":0,"passthru":false,"autocols":false,"showSearch":true,"selectionType":"click","columns":[{"title":"Name","key":"name","type":"text","width":"","align":"start"},{"title":"action","key":"action","type":"tickcross","width":"","align":"start"},{"title":"Last Action at","key":"datetime","type":"text","width":"","align":"start"}],"x":930,"y":700,"wires":[["f06bab117905eafe","42f2d5e780152b30","02543ea0037ac111","add0ee0fad25d2d6"]]},{"id":"4190fb92b50f9870","type":"sqlite","z":"8e6b07d1688aac0d","mydb":"f9551d91b22b1441","sqlquery":"msg.topic","sql":"","name":"","x":710,"y":700,"wires":[["b8ae4b7d1b7f9009"]]},{"id":"bb3f2d965caa8b65","type":"inject","z":"8e6b07d1688aac0d","name":"","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":"","payloadType":"date","x":220,"y":680,"wires":[["213c59fe7d209120"]]},{"id":"f06bab117905eafe","type":"debug","z":"8e6b07d1688aac0d","name":"debug 1","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","statusVal":"","statusType":"auto","x":1240,"y":700,"wires":[]},{"id":"aa9770ab985f1dff","type":"ui-control","z":"8e6b07d1688aac0d","name":"","ui":"174e44d306da2771","events":"all","x":200,"y":600,"wires":[["213c59fe7d209120"]]},{"id":"42f2d5e780152b30","type":"change","z":"8e6b07d1688aac0d","name":"","rules":[{"t":"set","p":"last_person","pt":"flow","to":"payload","tot":"msg"}],"action":"","property":"","from":"","to":"","reg":false,"x":1180,"y":760,"wires":[[]]},{"id":"9c9d40060387fc8d","type":"ui-button","z":"8e6b07d1688aac0d","group":"3c68ea2ef8aaa739","name":"","label":"Log-In","order":3,"width":"3","height":"1","emulateClick":false,"tooltip":"","color":"","bgcolor":"","className":"","icon":"","iconPosition":"left","payload":"last_person","payloadType":"flow","topic":"login","topicType":"str","buttonColor":"","textColor":"","iconColor":"","x":510,"y":1000,"wires":[["4310e1ba4a88d69a"]]},{"id":"7a6c36fe1c9ac3fa","type":"ui-button","z":"8e6b07d1688aac0d","group":"3c68ea2ef8aaa739","name":"","label":"Log-Out","order":4,"width":"3","height":"1","emulateClick":false,"tooltip":"","color":"","bgcolor":"","className":"","icon":"","iconPosition":"left","payload":"last_person","payloadType":"flow","topic":"logout","topicType":"str","buttonColor":"","textColor":"","iconColor":"","x":500,"y":1040,"wires":[["4310e1ba4a88d69a"]]},{"id":"ab16c0872ee524e0","type":"inject","z":"8e6b07d1688aac0d","name":"","props":[{"p":"payload"}],"repeat":"","crontab":"","once":true,"onceDelay":0.1,"topic":"","payload":"{}","payloadType":"json","x":210,"y":540,"wires":[["1b23cff4a27e596f"]]},{"id":"1b23cff4a27e596f","type":"change","z":"8e6b07d1688aac0d","name":"","rules":[{"t":"set","p":"last_person","pt":"flow","to":"payload","tot":"msg"}],"action":"","property":"","from":"","to":"","reg":false,"x":400,"y":540,"wires":[[]]},{"id":"df1531f868a360c1","type":"ui-notification","z":"8e6b07d1688aac0d","ui":"174e44d306da2771","position":"top right","colorDefault":true,"color":"#000000","displayTime":"3","showCountdown":true,"outputs":1,"allowDismiss":true,"dismissText":"Close","raw":false,"className":"","name":"","x":1280,"y":840,"wires":[[]]},{"id":"02543ea0037ac111","type":"template","z":"8e6b07d1688aac0d","name":"","field":"payload","fieldType":"msg","format":"handlebars","syntax":"mustache","template":"Person Selected: {{payload.name}}","output":"str","x":1040,"y":800,"wires":[["df1531f868a360c1"]]},{"id":"4310e1ba4a88d69a","type":"switch","z":"8e6b07d1688aac0d","name":"","property":"payload","propertyType":"msg","rules":[{"t":"hask","v":"id","vt":"str"}],"checkall":"true","repair":false,"outputs":1,"x":690,"y":1020,"wires":[["3227b4d019775deb","b1446043b451b420"]]},{"id":"3227b4d019775deb","type":"function","z":"8e6b07d1688aac0d","name":"function 1","func":"const person_id = msg.payload.id\nconst action = msg.topic == 'login' ? 1 : 0\nconst now =Date.now().valueOf()\n\nmsg.topic = `\nINSERT INTO log (person_id,action,created_at) \nVALUES (${person_id},${action},${now})\n` \n\n\nreturn msg;","outputs":1,"timeout":0,"noerr":0,"initialize":"","finalize":"","libs":[],"x":860,"y":1020,"wires":[["30a364adebb032fc"]]},{"id":"cbfc517bba77e70e","type":"sqlite","z":"8e6b07d1688aac0d","mydb":"f9551d91b22b1441","sqlquery":"msg.topic","sql":"","name":"","x":710,"y":440,"wires":[["640a537e09dba98f"]]},{"id":"8db480c05a13dcae","type":"inject","z":"8e6b07d1688aac0d","name":"","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":"","payloadType":"date","x":340,"y":440,"wires":[["d8d2c25af43d32c0"]]},{"id":"d8d2c25af43d32c0","type":"template","z":"8e6b07d1688aac0d","name":"Select Last","field":"topic","fieldType":"msg","format":"handlebars","syntax":"mustache","template":";with cte_last_status (person_id,action,created_at) AS\n(\n SELECT\n person_id,\n action,\n MAX(created_at) AS Last_created_at\n from log\n GROUP BY person_id\n)\nSelect * from cte_last_status\nINNER JOIN person\nON cte_last_status.person_id = person.id","output":"str","x":530,"y":440,"wires":[["cbfc517bba77e70e"]]},{"id":"640a537e09dba98f","type":"debug","z":"8e6b07d1688aac0d","name":"debug 2","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","statusVal":"","statusType":"auto","x":900,"y":440,"wires":[]},{"id":"b1446043b451b420","type":"debug","z":"8e6b07d1688aac0d","name":"debug 3","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","statusVal":"","statusType":"auto","x":820,"y":960,"wires":[]},{"id":"30a364adebb032fc","type":"sqlite","z":"8e6b07d1688aac0d","mydb":"f9551d91b22b1441","sqlquery":"msg.topic","sql":"","name":"","x":1030,"y":1020,"wires":[["213c59fe7d209120","2270a7a87ffda0e4"]]},{"id":"213c59fe7d209120","type":"template","z":"8e6b07d1688aac0d","name":"","field":"topic","fieldType":"msg","format":"handlebars","syntax":"mustache","template":";with cte_last_status (person_id,action,created_at) AS\n(\n SELECT\n person_id,\n action,\n MAX(created_at) AS Last_created_at\n from log\n GROUP BY person_id\n)\nSelect \n person.id,\n name,\n action,\n datetime(created_at / 1000, 'unixepoch') as [datetime]\n from cte_last_status\nINNER JOIN person\nON cte_last_status.person_id = person.id","output":"str","x":440,"y":700,"wires":[["4190fb92b50f9870"]]},{"id":"2270a7a87ffda0e4","type":"change","z":"8e6b07d1688aac0d","name":"","rules":[{"t":"set","p":"last_person","pt":"flow","to":"{}","tot":"json"}],"action":"","property":"","from":"","to":"","reg":false,"x":1220,"y":1080,"wires":[[]]},{"id":"94c0836789d72aa0","type":"ui-text","z":"8e6b07d1688aac0d","group":"3c68ea2ef8aaa739","order":2,"width":0,"height":0,"name":"","label":"","format":"{{msg.payload}}","layout":"row-left","style":false,"font":"","fontSize":16,"color":"#717171","className":"","x":1230,"y":640,"wires":[]},{"id":"add0ee0fad25d2d6","type":"template","z":"8e6b07d1688aac0d","name":"","field":"payload","fieldType":"msg","format":"handlebars","syntax":"mustache","template":"{{payload.name}} :","output":"str","x":1060,"y":640,"wires":[["94c0836789d72aa0"]]},{"id":"d35bccc73d26891b","type":"inject","z":"8e6b07d1688aac0d","name":"","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":"","payloadType":"date","x":380,"y":40,"wires":[["05332fd9affcc38e"]]},{"id":"05332fd9affcc38e","type":"template","z":"8e6b07d1688aac0d","name":"CREATE person","field":"payload","fieldType":"msg","format":"handlebars","syntax":"mustache","template":"CREATE TABLE \"person\" (\n\t\"id\"\tINTEGER NOT NULL UNIQUE,\n\t\"name\"\tTEXT NOT NULL,\n\tPRIMARY KEY(\"id\" AUTOINCREMENT)\n)","output":"str","x":600,"y":40,"wires":[["18a05a5c4c48c4a4"]]},{"id":"ee8deb38daea8aec","type":"template","z":"8e6b07d1688aac0d","name":"CREATE log","field":"payload","fieldType":"msg","format":"handlebars","syntax":"mustache","template":"CREATE TABLE \"log\" (\n\t\"id\"\tINTEGER NOT NULL UNIQUE,\n\t\"person_id\"\tINTEGER NOT NULL,\n\t\"action\"\tINTEGER NOT NULL,\n\t\"created_at\"\tINTEGER NOT NULL,\n\tPRIMARY KEY(\"id\" AUTOINCREMENT)\n)","output":"str","x":590,"y":80,"wires":[["809cf72ef5baf743"]]},{"id":"87bbeec09443b762","type":"inject","z":"8e6b07d1688aac0d","name":"","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":"","payloadType":"date","x":380,"y":80,"wires":[["ee8deb38daea8aec"]]},{"id":"18a05a5c4c48c4a4","type":"sqlite","z":"8e6b07d1688aac0d","mydb":"f9551d91b22b1441","sqlquery":"msg.topic","sql":"","name":"","x":790,"y":40,"wires":[[]]},{"id":"809cf72ef5baf743","type":"sqlite","z":"8e6b07d1688aac0d","mydb":"f9551d91b22b1441","sqlquery":"msg.topic","sql":"","name":"","x":790,"y":80,"wires":[[]]},{"id":"a7dd2167ef4c059a","type":"sqlite","z":"8e6b07d1688aac0d","mydb":"f9551d91b22b1441","sqlquery":"msg.topic","sql":"","name":"","x":730,"y":300,"wires":[["78eed5cae61be6e0"]]},{"id":"68795d2c9536c9db","type":"inject","z":"8e6b07d1688aac0d","name":"","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":"","payloadType":"date","x":360,"y":300,"wires":[["8d077a035546cb45","fcfdf1974398d2bb"]]},{"id":"8d077a035546cb45","type":"template","z":"8e6b07d1688aac0d","name":"Select person","field":"topic","fieldType":"msg","format":"handlebars","syntax":"mustache","template":"Select * from person","output":"str","x":560,"y":300,"wires":[["a7dd2167ef4c059a"]]},{"id":"78eed5cae61be6e0","type":"debug","z":"8e6b07d1688aac0d","name":"debug 4","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","statusVal":"","statusType":"auto","x":920,"y":300,"wires":[]},{"id":"fcfdf1974398d2bb","type":"template","z":"8e6b07d1688aac0d","name":"Select log","field":"topic","fieldType":"msg","format":"handlebars","syntax":"mustache","template":"Select * from log","output":"str","x":540,"y":340,"wires":[["a7dd2167ef4c059a"]]},{"id":"c920e9f315c0be84","type":"sqlite","z":"8e6b07d1688aac0d","mydb":"f9551d91b22b1441","sqlquery":"msg.topic","sql":"","name":"","x":730,"y":180,"wires":[["e74d253b284f8252"]]},{"id":"c2726e1c29d87303","type":"inject","z":"8e6b07d1688aac0d","name":"","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":"","payloadType":"date","x":360,"y":180,"wires":[["817821d3c68d3388"]]},{"id":"817821d3c68d3388","type":"template","z":"8e6b07d1688aac0d","name":"INSERT person","field":"topic","fieldType":"msg","format":"handlebars","syntax":"mustache","template":"INSERT INTO person (name)\nVALUES ('Mr. T'),('Superman'),('Neo')","output":"str","x":560,"y":180,"wires":[["c920e9f315c0be84"]]},{"id":"e74d253b284f8252","type":"debug","z":"8e6b07d1688aac0d","name":"debug 5","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"payload","targetType":"msg","statusVal":"","statusType":"auto","x":900,"y":180,"wires":[]},{"id":"3c68ea2ef8aaa739","type":"ui-group","name":"My Group","page":"7eacc83e5964c751","width":6,"height":1,"order":1,"showTitle":true,"className":"","visible":true,"disabled":false},{"id":"f9551d91b22b1441","type":"sqlitedb","db":"status.sqlite","mode":"RW"},{"id":"174e44d306da2771","type":"ui-base","name":"My Dashboard","path":"/dashboard","includeClientData":false,"acceptsClientConfig":["ui-notification","ui-control","ui-button"],"showPathInSidebar":false,"showPageTitle":true,"navigationStyle":"default","titleBarStyle":"default"},{"id":"7eacc83e5964c751","type":"ui-page","name":"Page 1","ui":"174e44d306da2771","path":"/page1","icon":"home","layout":"grid","theme":"171855b186577ac4","order":1,"className":"","visible":"true","disabled":"false"},{"id":"171855b186577ac4","type":"ui-theme","name":"Default Theme","colors":{"surface":"#ffffff","primary":"#0094CE","bgPage":"#eeeeee","groupBg":"#ffffff","groupOutline":"#cccccc"},"sizes":{"pagePadding":"12px","groupGap":"12px","groupBorderRadius":"4px","widgetGap":"12px"}}]